View: MRPFV_MDS_ENTRIES

Product:	MRP - Master Scheduling/MRP
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MRPFV_MDS_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
, SOHEADER.ORDER_NUMBER
, SOLINE.LINE_NUMBER
, PA2.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
, TO_NUMBER(DEMAND.DEMAND_SOURCE_LINE)
, 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
, SO_HEADERS_ALL SOHEADER
, SO_LINES_ALL SOLINE
, MTL_DEMAND_OMOE DEMAND
, 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 = 1
AND SCDA.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SCDA.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND SCDA.SOURCE_ORGANIZATION_ID = PA2.ORGANIZATION_ID(+)
AND SCDA.SOURCE_ORGANIZATION_ID = ORG2.ORGANIZATION_ID(+)
AND LI.LINE_ID(+) = SCDA.LINE_ID
AND LI.ORGANIZATION_ID(+) = SCDA.ORGANIZATION_ID
AND DEMAND.DEMAND_ID(+) = SCDA.RESERVATION_ID
AND SOLINE.LINE_ID(+) = DEMAND.DEMAND_SOURCE_LINE
AND SOHEADER.HEADER_ID(+) = SOLINE.HEADER_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