VIEW: APPS.MRPBV_MDS_ENTRIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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