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.FLM_SEQ_DEMAND_SALES_ORDERS_V

Source

View Text - Preformatted


SELECT OL.ROWID, OL.SHIP_FROM_ORG_ID, OL.INVENTORY_ITEM_ID, WL.LINE_ID, MRP_FLOW_SCHEDULE_UTIL.GET_ROUTING_DESIGNATOR(OL.INVENTORY_ITEM_ID, OL.SHIP_FROM_ORG_ID,WL.LINE_ID), OL.LINE_ID, MSI.CONCATENATED_SEGMENTS, CUST_PARTY.PARTY_NAME, LOC.ADDRESS1 , OL.DEMAND_CLASS_CODE, OL.SCHEDULE_SHIP_DATE, OL.LINE_NUMBER, OH.ORDER_NUMBER, OL.PLANNING_PRIORITY, INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(OL.SHIP_FROM_ORG_ID, OL.INVENTORY_ITEM_ID, OL.ORDER_QUANTITY_UOM, OL.ORDERED_QUANTITY), TO_CHAR(NULL), MRP_GET_PROJECT.PROJECT(OL.Project_Id), MRP_GET_PROJECT.TASK(OL.Task_Id), OL.LINE_NUMBER, GREATEST((INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(OL.SHIP_FROM_ORG_ID, OL.INVENTORY_ITEM_ID, OL.ORDER_QUANTITY_UOM, OL.ORDERED_QUANTITY) - MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(OL.LINE_ID,2,TO_CHAR(NULL), MSI.REPLENISH_TO_ORDER_FLAG) - MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY (OL.SHIP_FROM_ORG_ID,OL.INVENTORY_ITEM_ID,OL.LINE_ID,MSI.REPLENISH_TO_ORDER_FLAG)),0) FROM HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE, HZ_PARTIES CUST_PARTY, HZ_CUST_ACCOUNTS CUST_ACCNT, HZ_PARTY_SITES PARTY_SITE, HZ_CUST_SITE_USES_ALL RASU1, OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH, MTL_SYSTEM_ITEMS_KFV MSI, WIP_LINES WL, ( select OL2.line_id, decode ( (select 1 from oe_order_holds_all oh where oh.header_id = OL2.header_id and rownum = 1), null , 0, decode(OL2.ato_line_id, null, mrp_flow_schedule_util.check_holds(OL2.header_id, OL2.line_id, 'OEOL', 'LINE_SCHEDULING'), mrp_flow_schedule_util.check_holds(OL2.header_id, OL2.line_id, null, null) )) hold from oe_order_lines_all OL2 ) line_holds, ( select OL2.line_id, CTO_WIP_WORKFLOW_API_PK.workflow_build_status(OL2.LINE_ID) status from oe_order_lines_all OL2 ) line_build WHERE RASU1.SITE_USE_ID (+)= OL.SHIP_TO_ORG_ID and acct_site.cust_acct_site_id(+) = rasu1.cust_acct_site_id and ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID AND CUST_ACCNT.CUST_ACCOUNT_ID (+)= OL.SOLD_TO_ORG_ID AND CUST_PARTY.PARTY_ID = CUST_ACCNT.PARTY_ID and line_build.line_id = OL.line_id AND 1 = decode(MSI.REPLENISH_TO_ORDER_FLAG, 'N',1, line_build.status) AND MSI.BUILD_IN_WIP_FLAG = 'Y' AND MSI.PICK_COMPONENTS_FLAG = 'N' AND MSI.BOM_ITEM_TYPE = 4 AND MSI.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID AND MSI.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID AND OL.ORDERED_QUANTITY > 0 AND OL.VISIBLE_DEMAND_FLAG = 'Y' AND OL.OPEN_FLAG = 'Y' AND OL.HEADER_ID = OH.HEADER_ID AND OL.ITEM_TYPE_CODE in ('STANDARD', 'CONFIG', 'INCLUDED','OPTION') AND OL.SHIPPED_QUANTITY is NULL and OL.line_id = line_holds.line_id and line_holds.hold = 0 AND wl.organization_id = OL.ship_from_org_id AND wl.line_id in (select line_id from bom_operational_routings bor2 where bor2.assembly_item_id = OL.inventory_item_id and bor2.organization_id = OL.ship_from_org_id and bor2.cfm_routing_flag = 1 ) AND NVL(OL.FULFILLED_FLAG,'N') <> 'Y'

View Text - HTML Formatted

SELECT OL.ROWID
, OL.SHIP_FROM_ORG_ID
, OL.INVENTORY_ITEM_ID
, WL.LINE_ID
, MRP_FLOW_SCHEDULE_UTIL.GET_ROUTING_DESIGNATOR(OL.INVENTORY_ITEM_ID
, OL.SHIP_FROM_ORG_ID
, WL.LINE_ID)
, OL.LINE_ID
, MSI.CONCATENATED_SEGMENTS
, CUST_PARTY.PARTY_NAME
, LOC.ADDRESS1
, OL.DEMAND_CLASS_CODE
, OL.SCHEDULE_SHIP_DATE
, OL.LINE_NUMBER
, OH.ORDER_NUMBER
, OL.PLANNING_PRIORITY
, INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(OL.SHIP_FROM_ORG_ID
, OL.INVENTORY_ITEM_ID
, OL.ORDER_QUANTITY_UOM
, OL.ORDERED_QUANTITY)
, TO_CHAR(NULL)
, MRP_GET_PROJECT.PROJECT(OL.PROJECT_ID)
, MRP_GET_PROJECT.TASK(OL.TASK_ID)
, OL.LINE_NUMBER
, GREATEST((INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(OL.SHIP_FROM_ORG_ID
, OL.INVENTORY_ITEM_ID
, OL.ORDER_QUANTITY_UOM
, OL.ORDERED_QUANTITY) - MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(OL.LINE_ID
, 2
, TO_CHAR(NULL)
, MSI.REPLENISH_TO_ORDER_FLAG) - MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY (OL.SHIP_FROM_ORG_ID
, OL.INVENTORY_ITEM_ID
, OL.LINE_ID
, MSI.REPLENISH_TO_ORDER_FLAG))
, 0)
FROM HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_PARTIES CUST_PARTY
, HZ_CUST_ACCOUNTS CUST_ACCNT
, HZ_PARTY_SITES PARTY_SITE
, HZ_CUST_SITE_USES_ALL RASU1
, OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS_ALL OH
, MTL_SYSTEM_ITEMS_KFV MSI
, WIP_LINES WL
, ( SELECT OL2.LINE_ID
, DECODE ( (SELECT 1
FROM OE_ORDER_HOLDS_ALL OH
WHERE OH.HEADER_ID = OL2.HEADER_ID
AND ROWNUM = 1)
, NULL
, 0
, DECODE(OL2.ATO_LINE_ID
, NULL
, MRP_FLOW_SCHEDULE_UTIL.CHECK_HOLDS(OL2.HEADER_ID
, OL2.LINE_ID
, 'OEOL'
, 'LINE_SCHEDULING')
, MRP_FLOW_SCHEDULE_UTIL.CHECK_HOLDS(OL2.HEADER_ID
, OL2.LINE_ID
, NULL
, NULL) )) HOLD
FROM OE_ORDER_LINES_ALL OL2 ) LINE_HOLDS
, ( SELECT OL2.LINE_ID
, CTO_WIP_WORKFLOW_API_PK.WORKFLOW_BUILD_STATUS(OL2.LINE_ID) STATUS
FROM OE_ORDER_LINES_ALL OL2 ) LINE_BUILD
WHERE RASU1.SITE_USE_ID (+)= OL.SHIP_TO_ORG_ID
AND ACCT_SITE.CUST_ACCT_SITE_ID(+) = RASU1.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
AND CUST_ACCNT.CUST_ACCOUNT_ID (+)= OL.SOLD_TO_ORG_ID
AND CUST_PARTY.PARTY_ID = CUST_ACCNT.PARTY_ID
AND LINE_BUILD.LINE_ID = OL.LINE_ID
AND 1 = DECODE(MSI.REPLENISH_TO_ORDER_FLAG
, 'N'
, 1
, LINE_BUILD.STATUS)
AND MSI.BUILD_IN_WIP_FLAG = 'Y'
AND MSI.PICK_COMPONENTS_FLAG = 'N'
AND MSI.BOM_ITEM_TYPE = 4
AND MSI.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
AND MSI.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID
AND OL.ORDERED_QUANTITY > 0
AND OL.VISIBLE_DEMAND_FLAG = 'Y'
AND OL.OPEN_FLAG = 'Y'
AND OL.HEADER_ID = OH.HEADER_ID
AND OL.ITEM_TYPE_CODE IN ('STANDARD'
, 'CONFIG'
, 'INCLUDED'
, 'OPTION')
AND OL.SHIPPED_QUANTITY IS NULL
AND OL.LINE_ID = LINE_HOLDS.LINE_ID
AND LINE_HOLDS.HOLD = 0
AND WL.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
AND WL.LINE_ID IN (SELECT LINE_ID
FROM BOM_OPERATIONAL_ROUTINGS BOR2
WHERE BOR2.ASSEMBLY_ITEM_ID = OL.INVENTORY_ITEM_ID
AND BOR2.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
AND BOR2.CFM_ROUTING_FLAG = 1 )
AND NVL(OL.FULFILLED_FLAG
, 'N') <> 'Y'