[Home] [Help]
View: MRPFV_MASTER_DEMAND_SCHEDS
View Text
SELECT PA.ORGANIZATION_CODE
, AL.NAME
, SC.SCHEDULE_DESIGNATOR
, SC.DESCRIPTION
, SC.DEMAND_CLASS
, LKUP.MEANING
, SC.DISABLE_DATE
, '_DF:MRP:MRP_SCHEDULE_DESIGNATORS:SC'
, SC.ORGANIZATION_ID
, SC.LAST_UPDATE_DATE
, SC.LAST_UPDATED_BY
, SC.CREATION_DATE
, SC.CREATED_BY
FROM MFG_LOOKUPS LKUP
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_SCHEDULE_DESIGNATORS SC
WHERE SC.SCHEDULE_TYPE = 1
AND SC.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SC.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND LKUP.LOOKUP_CODE = SC.MPS_RELIEF
AND LKUP.LOOKUP_TYPE = 'SYS_YES_NO'
AND '_SEC:SC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
| Name |
| ORGANIZATION_CODE |
| ORGANIZATION_NAME |
| SCHEDULE_NAME |
| SCHEDULE_DESCRIPTION |
| DEMAND_CLASS |
| RELIEF_FLAG |
| INACTIVE_DATE |
| "_DF" |
| ORGANIZATION_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
APPS.MRPFV_MASTER_DEMAND_SCHEDS