Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.MRPBV_MASTER_PROD_SCHEDS |
SELECT PA.ORGANIZATION_CODE
, AL.NAME
, SC.SCHEDULE_DESIGNATOR
, SC.DESCRIPTION
, SC.DEMAND_CLASS
, '_LA:SC.MPS_RELIEF:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:SC.INVENTORY_ATP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:SC.PRODUCTION:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, SC.DISABLE_DATE
, SC.ORGANIZATION_ID
, SC.LAST_UPDATE_DATE
, SC.LAST_UPDATED_BY
, SC.CREATION_DATE
, SC.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_SCHEDULE_DESIGNATORS SC
WHERE SC.SCHEDULE_TYPE = 2
AND SC.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SC.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:SC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY