View: MRP_SCATP_SUPPLY_SOURCES_V

Product:	MRP - Master Scheduling/MRP
Description:	Supply Chain ATP supply source view
Implementation/DBA Data:	APPS.MRP_SCATP_SUPPLY_SOURCES_V

View Text

SELECT DISTINCT D.SESSION_ID
, D.SCHEDULE_GROUP_ID
, D.ATP_GROUP_ID
, D.ORGANIZATION_ID
, P.ORGANIZATION_CODE
, D.SHIP_METHOD
, FND.MEANING
, D.INTRANSIT_LEAD_TIME
, D.VENDOR_ID
, VENDOR.VENDOR_NAME
, D.VENDOR_SITE_ID
, SITE.VENDOR_SITE_CODE
, D.GROUP_AVAILABLE_DATE
, D.GROUP_ATP_CHECK
FROM PO_VENDOR_SITES_ALL SITE
, PO_VENDORS VENDOR
, FND_COMMON_LOOKUPS FND
, MTL_PARAMETERS P
, MTL_DEMAND_INTERFACE D
WHERE P.ORGANIZATION_ID = D.ORGANIZATION_ID
AND FND.LOOKUP_CODE (+) = D.SHIP_METHOD
AND FND.LOOKUP_TYPE (+) = 'SHIP_METHOD'
AND FND.APPLICATION_ID (+) = 401
AND VENDOR.VENDOR_ID (+) = D.VENDOR_ID
AND SITE.VENDOR_SITE_ID (+) = D.VENDOR_SITE_ID

Columns