VIEW: APPS.MRPFV_MPS_ENTRIES

Source

View Text - Preformatted

SELECT PA.ORGANIZATION_CODE , ORG.NAME , SCDA.SCHEDULE_DESIGNATOR , SCDA.SCHEDULE_DATE , SCDA.RATE_END_DATE , SCDA.SCHEDULE_QUANTITY , SCDA.ORIGINAL_SCHEDULE_QUANTITY , SCDA.REPETITIVE_DAILY_RATE , LKUP.MEANING , SCDA.SCHEDULE_COMMENTS , SCDA.SOURCE_FORECAST_DESIGNATOR , PA.ORGANIZATION_CODE , ORG2.NAME , SCDA.SOURCE_SCHEDULE_DESIGNATOR , MRP_GET_PROJECT.PROJECT(SCDA.PROJECT_ID) , MRP_GET_PROJECT.TASK(SCDA.TASK_ID) , LI.LINE_CODE , SCDA.END_ITEM_UNIT_NUMBER , '_DF:MRP:MRP_SCHEDULE_DATES:SCDA' , SCDA.MPS_TRANSACTION_ID , SCDA.REFERENCE_SCHEDULE_ID , SCDA.SOURCE_ORGANIZATION_ID , SCDA.INVENTORY_ITEM_ID , SCDA.ORGANIZATION_ID , SCDA.FORECAST_ID , SCDA.PROJECT_ID , SCDA.TASK_ID , SCDA.LINE_ID , SCDA.LAST_UPDATE_DATE , SCDA.LAST_UPDATED_BY , SCDA.CREATION_DATE , SCDA.CREATED_BY FROM MFG_LOOKUPS LKUP ,WIP_LINES LI ,MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS ORG ,MTL_PARAMETERS PA2 ,HR_ALL_ORGANIZATION_UNITS ORG2 ,MRP_SCHEDULE_DESIGNATORS SCDE ,MRP_SCHEDULE_ITEMS SCIT ,MRP_SCHEDULE_DATES SCDA WHERE SCDA.INVENTORY_ITEM_ID = SCIT.INVENTORY_ITEM_ID AND SCDA.ORGANIZATION_ID = SCIT.ORGANIZATION_ID AND SCDA.SCHEDULE_DESIGNATOR = SCIT.SCHEDULE_DESIGNATOR AND SCIT.ORGANIZATION_ID = SCDE.ORGANIZATION_ID AND SCIT.SCHEDULE_DESIGNATOR = SCDE.SCHEDULE_DESIGNATOR AND SCDE.SCHEDULE_TYPE = 2 AND PA.ORGANIZATION_ID = SCDA.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = SCDA.ORGANIZATION_ID AND PA2.ORGANIZATION_ID(+) = SCDA.SOURCE_ORGANIZATION_ID AND ORG2.ORGANIZATION_ID(+) = SCDA.SOURCE_ORGANIZATION_ID AND LI.LINE_ID(+) = SCDA.LINE_ID AND LI.ORGANIZATION_ID(+) = SCDA.ORGANIZATION_ID AND LKUP.LOOKUP_CODE = SCDA.SCHEDULE_ORIGINATION_TYPE AND LKUP.LOOKUP_TYPE = 'MRP_SCHEDULE_ORIG' AND '_SEC:SCDA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE
, ORG.NAME
, SCDA.SCHEDULE_DESIGNATOR
, SCDA.SCHEDULE_DATE
, SCDA.RATE_END_DATE
, SCDA.SCHEDULE_QUANTITY
, SCDA.ORIGINAL_SCHEDULE_QUANTITY
, SCDA.REPETITIVE_DAILY_RATE
, LKUP.MEANING
, SCDA.SCHEDULE_COMMENTS
, SCDA.SOURCE_FORECAST_DESIGNATOR
, PA.ORGANIZATION_CODE
, ORG2.NAME
, SCDA.SOURCE_SCHEDULE_DESIGNATOR
, MRP_GET_PROJECT.PROJECT(SCDA.PROJECT_ID)
, MRP_GET_PROJECT.TASK(SCDA.TASK_ID)
, LI.LINE_CODE
, SCDA.END_ITEM_UNIT_NUMBER
, '_DF:MRP:MRP_SCHEDULE_DATES:SCDA'
, SCDA.MPS_TRANSACTION_ID
, SCDA.REFERENCE_SCHEDULE_ID
, SCDA.SOURCE_ORGANIZATION_ID
, SCDA.INVENTORY_ITEM_ID
, SCDA.ORGANIZATION_ID
, SCDA.FORECAST_ID
, SCDA.PROJECT_ID
, SCDA.TASK_ID
, SCDA.LINE_ID
, SCDA.LAST_UPDATE_DATE
, SCDA.LAST_UPDATED_BY
, SCDA.CREATION_DATE
, SCDA.CREATED_BY
FROM MFG_LOOKUPS LKUP
, WIP_LINES LI
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_PARAMETERS PA2
, HR_ALL_ORGANIZATION_UNITS ORG2
, MRP_SCHEDULE_DESIGNATORS SCDE
, MRP_SCHEDULE_ITEMS SCIT
, MRP_SCHEDULE_DATES SCDA
WHERE SCDA.INVENTORY_ITEM_ID = SCIT.INVENTORY_ITEM_ID
AND SCDA.ORGANIZATION_ID = SCIT.ORGANIZATION_ID
AND SCDA.SCHEDULE_DESIGNATOR = SCIT.SCHEDULE_DESIGNATOR
AND SCIT.ORGANIZATION_ID = SCDE.ORGANIZATION_ID
AND SCIT.SCHEDULE_DESIGNATOR = SCDE.SCHEDULE_DESIGNATOR
AND SCDE.SCHEDULE_TYPE = 2
AND PA.ORGANIZATION_ID = SCDA.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = SCDA.ORGANIZATION_ID
AND PA2.ORGANIZATION_ID(+) = SCDA.SOURCE_ORGANIZATION_ID
AND ORG2.ORGANIZATION_ID(+) = SCDA.SOURCE_ORGANIZATION_ID
AND LI.LINE_ID(+) = SCDA.LINE_ID
AND LI.ORGANIZATION_ID(+) = SCDA.ORGANIZATION_ID
AND LKUP.LOOKUP_CODE = SCDA.SCHEDULE_ORIGINATION_TYPE
AND LKUP.LOOKUP_TYPE = 'MRP_SCHEDULE_ORIG'
AND '_SEC:SCDA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY