View: MRP_BIS_LATE_ORDERS_V

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

View Text

SELECT GREQ.COMPILE_DESIGNATOR
, GREQ.ORGANIZATION_ID
, MSI.CONCATENATED_SEGMENTS
, DEM.ORDERED_QUANTITY
, DEM.ORDER_QUANTITY_UOM
, DEM.SCHEDULE_SHIP_DATE
, (DEM.SCHEDULE_SHIP_DATE + MRP_GET_BIS_VALUES.EXPECTED_SHIP_DATE( GREQ.DISPOSITION_ID
, GREQ.ORGANIZATION_ID
, GREQ.COMPILE_DESIGNATOR))
, INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER(DEM.HEADER_ID)
, MRP_GET_ORDER.SALES_ORDER(GREQ.DISPOSITION_ID)
, DEM.LINE_ID
, DEM.LINE_NUMBER
, DEM.SOLD_TO_ORG_ID
, RAC.CUSTOMER_NAME
, DEM.SHIP_TO_ORG_ID
, RAD.ADDRESS1
FROM RA_ADDRESSES_ALL RAD
, RA_CUSTOMERS RAC
, RA_SITE_USES_ALL RASU
, MTL_SYSTEM_ITEMS_KFV MSI
, OE_ORDER_LINES_ALL DEM
, MRP_SCHEDULE_DATES DATES
, MRP_FULL_PEGGING PEG
, MRP_EXCEPTION_DETAILS MED
, MRP_GROSS_REQUIREMENTS GREQ
WHERE RAD.ADDRESS_ID(+) = RASU.ADDRESS_ID
AND RAC.CUSTOMER_ID(+) = DEM.SOLD_TO_ORG_ID
AND RASU.SITE_USE_ID(+) = DEM.SHIP_TO_ORG_ID
AND MSI.INVENTORY_ITEM_ID = GREQ.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = GREQ.ORGANIZATION_ID
AND DEM.LINE_ID = DATES.RESERVATION_ID
AND DATES.SCHEDULE_LEVEL = 3
AND DATES.MPS_TRANSACTION_ID = GREQ.DISPOSITION_ID
AND MED.NUMBER2 = PEG.PEGGING_ID
AND GREQ.DEMAND_ID = PEG.DEMAND_ID
AND MED.EXCEPTION_TYPE IN (13
, 15)
AND GREQ.ORGANIZATION_ID = MED.ORGANIZATION_ID
AND GREQ.INVENTORY_ITEM_ID = MED.INVENTORY_ITEM_ID
AND GREQ.COMPILE_DESIGNATOR = MED.COMPILE_DESIGNATOR
AND GREQ.ORIGINATION_TYPE = 6 UNION ALL SELECT GREQ.COMPILE_DESIGNATOR
, GREQ.ORGANIZATION_ID
, MSI.CONCATENATED_SEGMENTS
, GREQ.USING_REQUIREMENTS_QUANTITY
, MSI.PRIMARY_UOM_CODE
, PEG.DEMAND_DATE
, (PEG.DEMAND_DATE + MRP_GET_BIS_VALUES.EXPECTED_SHIP_DATE( GREQ.DISPOSITION_ID
, GREQ.ORGANIZATION_ID
, GREQ.COMPILE_DESIGNATOR))
, TO_NUMBER(NULL)
, DATES.SOURCE_FORECAST_DESIGNATOR
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
FROM MTL_SYSTEM_ITEMS_KFV MSI
, MRP_SCHEDULE_DATES DATES
, MRP_FULL_PEGGING PEG
, MRP_EXCEPTION_DETAILS MED
, MRP_GROSS_REQUIREMENTS GREQ
WHERE MSI.INVENTORY_ITEM_ID = GREQ.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = GREQ.ORGANIZATION_ID
AND DATES.SCHEDULE_LEVEL = 3
AND DATES.MPS_TRANSACTION_ID = GREQ.DISPOSITION_ID
AND GREQ.ORIGINATION_TYPE = 7
AND MED.NUMBER2 = PEG.PEGGING_ID
AND GREQ.DEMAND_ID = PEG.DEMAND_ID
AND MED.EXCEPTION_TYPE IN (14
, 16)

Columns