eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MRP_BIS_LATE_ORDERS_V

Source

View Text - Preformatted


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.DEMAND_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 , substrb(PARTY.PARTY_NAME, 1, 50) ,DEM.SHIP_TO_ORG_ID , LOC.ADDRESS1 FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT, HZ_CUST_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 CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+) AND ACCT_SITE.CUST_ACCT_SITE_ID(+) = RASU.CUST_ACCT_SITE_ID AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+) AND LOC.LOCATION_ID(+) = PARTY_SITE.LOCATION_ID AND CUST_ACCT.CUST_ACCOUNT_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.DEMAND_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)

View Text - HTML Formatted

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.DEMAND_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
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, DEM.SHIP_TO_ORG_ID
, LOC.ADDRESS1
FROM HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_CUST_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 CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND ACCT_SITE.CUST_ACCT_SITE_ID(+) = RASU.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+)
AND LOC.LOCATION_ID(+) = PARTY_SITE.LOCATION_ID
AND CUST_ACCT.CUST_ACCOUNT_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.DEMAND_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)