DOS_SUPPLY_BUY_ORDER_DTLS_V
Details
-
Schema: FUSION
-
Object owner: DOS
-
Object type: VIEW
Columns
Name |
---|
SUPPLY_BUY_ORD_DTLS_ID TRACKING_LINE_ID BATCH_ID GROUP_CODE PREPARER_ID EARLIEST_SHIP_DATE DELIVERY_LEAD_TIME DELIVER_TO_LOCATION_ID SUGGESTED_VENDOR_ID SUGGESTED_VENDOR_SITE_ID DELIVER_TO_REQUESTOR_ID REQUISITION_SOURCE_TYPE_CODE DESTINATION_TYPE_CODE AUTOSOURCE_FLAG SHIPPING_METHOD END_INVENTORY_ITEM_ID REQUISITION_LINE_ID PURCHASE_ORDER_HEADER_ID PURCHASE_ORDER_NUMBER PURCHASE_ORDER_LINE_ID PURCHASE_ORDER_LINE_NUMBER LINE_LOCATION_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SCHEDULED_SHIP_DATE LINE_TYPE_ID DISTRIBUTION_ID REQUISITION_LINE_NUMBER REQUISITION_NUMBER REQUISITIONING_BU_ID AUTHORIZATION_STATUS DESTINATION_SUBINVENTORY_CODE EXEC_SYSTEM_DELIVER_TO_SUBINV EXEC_SYSTEM_DELVR_TO_LOC_NAME EXEC_SYSTEM_DELVR_TO_REQUESTOR EXEC_SYSTEM_SUGGESTED_VENDOR EXEC_SYSTEM_SUGSTD_VENDOR_SITE BUYER_ID CATEGORY_ID REQUESTED_SHIP_DATE CHANGE_SUPPLY_OPERATION PRIMARY_DOC_QUANTITY PRIMARY_DOC_QUANTITY_UOM SHIPMENT_PRIORITY_CODE EXEC_SYSTEM_DESTN_LOCTR_CODE |
Query
SQL_Statement |
---|
SELECT SUPPLY_BUY_ORD_DTLS_ID, TRACKING_LINE_ID, BATCH_ID, GROUP_CODE, PREPARER_ID, EARLIEST_SHIP_DATE, DELIVERY_LEAD_TIME, DELIVER_TO_LOCATION_ID, SUGGESTED_VENDOR_ID, SUGGESTED_VENDOR_SITE_ID, DELIVER_TO_REQUESTOR_ID, REQUISITION_SOURCE_TYPE_CODE, DESTINATION_TYPE_CODE, AUTOSOURCE_FLAG, SHIPPING_METHOD, END_INVENTORY_ITEM_ID, REQUISITION_LINE_ID, PURCHASE_ORDER_HEADER_ID, PURCHASE_ORDER_NUMBER, PURCHASE_ORDER_LINE_ID, PURCHASE_ORDER_LINE_NUMBER, LINE_LOCATION_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SCHEDULED_SHIP_DATE, LINE_TYPE_ID, DISTRIBUTION_ID, REQUISITION_LINE_NUMBER, REQUISITION_NUMBER, REQUISITIONING_BU_ID, AUTHORIZATION_STATUS, DESTINATION_SUBINVENTORY_CODE, EXEC_SYSTEM_DELIVER_TO_SUBINV, EXEC_SYSTEM_DELVR_TO_LOC_NAME, EXEC_SYSTEM_DELVR_TO_REQUESTOR, EXEC_SYSTEM_SUGGESTED_VENDOR, EXEC_SYSTEM_SUGSTD_VENDOR_SITE, BUYER_ID, CATEGORY_ID, REQUESTED_SHIP_DATE, CHANGE_SUPPLY_OPERATION, PRIMARY_DOC_QUANTITY, PRIMARY_DOC_QUANTITY_UOM, SHIPMENT_PRIORITY_CODE, EXEC_SYSTEM_DESTN_LOCTR_CODE FROM DOS_SUPPLY_BUY_ORDER_DTLS |