View: MRPBV_MDS_ENTRIES

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

View Text

SELECT SCDA.SCHEDULE_DATE
, SCDA.RATE_END_DATE
, SCDA.SCHEDULE_QUANTITY
, SCDA.ORIGINAL_SCHEDULE_QUANTITY
, SCDA.REPETITIVE_DAILY_RATE
, LKUP.MEANING
, SCDA.SCHEDULE_COMMENTS
, SCDA.MPS_TRANSACTION_ID
, SCDA.SOURCE_FORECAST_DESIGNATOR
, SCDA.REFERENCE_SCHEDULE_ID
, SCDA.SOURCE_ORGANIZATION_ID
, SCDA.SOURCE_SCHEDULE_DESIGNATOR
, SCDA.END_ITEM_UNIT_NUMBER
, SCDA.INVENTORY_ITEM_ID
, SCDA.ORGANIZATION_ID
, SCDA.SCHEDULE_DESIGNATOR
, 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
, MTL_DEMAND_OMOE DEMAND
, 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.RESERVATION_ID = DEMAND.DEMAND_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