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 |