DOS_SUPPLY_TRACKING_LINES_V

Details

• Schema: FUSION

• Object owner: DOS

• Object type: VIEW

Columns

Name

HEADER_ID LINE_ID TRACKING_LINE_ID PARENT_TRACKING_LINE_ID TRACKING_LINE_NUMBER STATUS_CODE INVENTORY_ITEM_ID ITEM_REVISION UOM_CODE QUANTITY NEED_BY_DATE HOLD_FLAG DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_CODE CANCEL_REASON_CODE CANCEL_COMMENTS SUPPLY_SET CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESTINATION_BU_ID OBJECT_VERSION_NUMBER SUPPLY_OPERATION SUPPLY_TYPE SUPPLY_SOURCE_SYSTEM SUPPLY_ORDER_REF_LINE_NUMBER SUPPLY_ORDER_REFERENCE_LINE_ID ITEM_TYPE EXCEPTION_FLAG SECONDARY_QUANTITY SECONDARY_UOM_CODE SPLIT_FROM_TLINE_ID EXEC_SYSTEM_PROJECT_ID EXEC_SYSTEM_PROJECT_NAME EXEC_SYSTEM_TASK_ID EXEC_SYSTEM_TASK_NAME OPEN_FLAG CHANGE_PENDING_FLAG CHANGE_REQUEST_ACTION_CODE CANCELED_FLAG

Query

SQL_Statement

SELECT HEADER_ID, LINE_ID, TRACKING_LINE_ID, PARENT_TRACKING_LINE_ID, TRACKING_LINE_NUMBER, STATUS_CODE, INVENTORY_ITEM_ID, ITEM_REVISION, UOM_CODE, QUANTITY, NEED_BY_DATE, HOLD_FLAG, DESTINATION_ORGANIZATION_ID, DESTINATION_ORGANIZATION_CODE, CANCEL_REASON_CODE, CANCEL_COMMENTS, SUPPLY_SET, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, DESTINATION_BU_ID, OBJECT_VERSION_NUMBER, SUPPLY_OPERATION, SUPPLY_TYPE, SUPPLY_SOURCE_SYSTEM, SUPPLY_ORDER_REF_LINE_NUMBER, SUPPLY_ORDER_REFERENCE_LINE_ID, ITEM_TYPE, EXCEPTION_FLAG, SECONDARY_QUANTITY, SECONDARY_UOM_CODE, SPLIT_FROM_TLINE_ID, EXEC_SYSTEM_PROJECT_ID, EXEC_SYSTEM_PROJECT_NAME, EXEC_SYSTEM_TASK_ID, EXEC_SYSTEM_TASK_NAME, OPEN_FLAG, CHANGE_PENDING_FLAG, CHANGE_REQUEST_ACTION_CODE, CANCELED_FLAG FROM DOS_SUPPLY_TRACKING_LINES