DBA Data[Home] [Help]

VIEW: APPS.MRP_ATP_SOURCES_V

Source

View Text - Preformatted

SELECT DISTINCT SOURCE_ORGANIZATION_ID, SOURCE_ORGANIZATION_CODE, VENDOR_ID, VENDOR_NAME, VENDOR_SITE_ID, VENDOR_SITE_NAME, SHIP_METHOD, SHIP_METHOD_TEXT, DELIVERY_LEAD_TIME, CUSTOMER_ID, CUSTOMER_SITE_ID, INSTANCE_ID1, SR_INSTANCE_ID, ORGANIZATION_ID, SESSION_ID, STATUS_FLAG FROM MRP_ATP_SCHEDULE_TEMP
View Text - HTML Formatted

SELECT DISTINCT SOURCE_ORGANIZATION_ID
, SOURCE_ORGANIZATION_CODE
, VENDOR_ID
, VENDOR_NAME
, VENDOR_SITE_ID
, VENDOR_SITE_NAME
, SHIP_METHOD
, SHIP_METHOD_TEXT
, DELIVERY_LEAD_TIME
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, INSTANCE_ID1
, SR_INSTANCE_ID
, ORGANIZATION_ID
, SESSION_ID
, STATUS_FLAG
FROM MRP_ATP_SCHEDULE_TEMP