DOS_SUPPLY_BUY_ORDER_DTLS

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

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

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