View: MRPFV_MPS_ENTRIES

Product:	MRP - Master Scheduling/MRP
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MRPFV_MPS_ENTRIES

View Text

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

Columns