DOS_SUPPLY_LINES_V

Details

• Schema: FUSION

• Object owner: DOS

• Object type: VIEW

Columns

Name

LINE_ID OBJECT_VERSION_NUMBER HEADER_ID PARENT_LINE_ID LINE_NUMBER SUPPLY_OPERATION SUPPLY_TYPE SUPPLY_SOURCE_SYSTEM INVENTORY_ITEM_ID ITEM_REVISION UOM_CODE QUANTITY SUPPLY_ORDER_REFERENCE_LINE_ID DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_CODE CHANGE_PENDING_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESTINATION_BU_ID SUPPLY_ORDER_REF_LINE_NUMBER ITEM_TYPE STATUS_CODE ITEM_DESCRIPTION SECONDARY_QUANTITY SECONDARY_UOM_CODE NEED_BY_DATE EXEC_SYSTEM_ITEM_NUMBER

Query

SQL_Statement

SELECT LINE_ID, OBJECT_VERSION_NUMBER, HEADER_ID, PARENT_LINE_ID, LINE_NUMBER, SUPPLY_OPERATION, SUPPLY_TYPE, SUPPLY_SOURCE_SYSTEM, INVENTORY_ITEM_ID, ITEM_REVISION, UOM_CODE, QUANTITY, SUPPLY_ORDER_REFERENCE_LINE_ID, DESTINATION_ORGANIZATION_ID, DESTINATION_ORGANIZATION_CODE, CHANGE_PENDING_FLAG, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, DESTINATION_BU_ID, SUPPLY_ORDER_REF_LINE_NUMBER, ITEM_TYPE, STATUS_CODE, ITEM_DESCRIPTION, SECONDARY_QUANTITY, SECONDARY_UOM_CODE, NEED_BY_DATE, EXEC_SYSTEM_ITEM_NUMBER FROM DOS_SUPPLY_LINES