VIEW: APPS.ASO_PVT_PENDING_ORDERS_BALI_V

Source

View Text - Preformatted

SELECT items.concatenated_segments inventory_item, items.description item_description, header.order_number, lines.line_number, header.ordered_date, lines.org_id, header.header_id, lines.line_id, lines.inventory_item_id, items.organization_id, lines.ordered_quantity quantity, lines.order_quantity_uom uom_code, lines.line_category_code, lines.cust_po_number cust_po_number, lines.sold_to_org_id cust_account_id, mic.category_id, mic.category_set_id FROM oe_order_lines_all lines, oe_order_headers header, mtl_system_items_vl items, mtl_item_categories mic WHERE lines.header_id = header.header_id and lines.inventory_item_id = items.inventory_item_id and items.organization_id = oe_profile.value('OE_ORGANIZATION_ID',lines.org_id) and items.serviceable_product_flag = 'Y' and lines.open_flag = 'Y' and lines.line_category_code <> 'RETURN' and lines.ordered_quantity > 0 and items.inventory_item_id = mic.inventory_item_id and items.organization_id = mic.organization_id and lines.org_id = header.org_id

View Text - HTML Formatted

SELECT ITEMS.CONCATENATED_SEGMENTS INVENTORY_ITEM
, ITEMS.DESCRIPTION ITEM_DESCRIPTION
, HEADER.ORDER_NUMBER
, LINES.LINE_NUMBER
, HEADER.ORDERED_DATE
, LINES.ORG_ID
, HEADER.HEADER_ID
, LINES.LINE_ID
, LINES.INVENTORY_ITEM_ID
, ITEMS.ORGANIZATION_ID
, LINES.ORDERED_QUANTITY QUANTITY
, LINES.ORDER_QUANTITY_UOM UOM_CODE
, LINES.LINE_CATEGORY_CODE
, LINES.CUST_PO_NUMBER CUST_PO_NUMBER
, LINES.SOLD_TO_ORG_ID CUST_ACCOUNT_ID
, MIC.CATEGORY_ID
, MIC.CATEGORY_SET_ID
FROM OE_ORDER_LINES_ALL LINES
, OE_ORDER_HEADERS HEADER
, MTL_SYSTEM_ITEMS_VL ITEMS
, MTL_ITEM_CATEGORIES MIC
WHERE LINES.HEADER_ID = HEADER.HEADER_ID
AND LINES.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND ITEMS.ORGANIZATION_ID = OE_PROFILE.VALUE('OE_ORGANIZATION_ID'
, LINES.ORG_ID)
AND ITEMS.SERVICEABLE_PRODUCT_FLAG = 'Y'
AND LINES.OPEN_FLAG = 'Y'
AND LINES.LINE_CATEGORY_CODE <> 'RETURN'
AND LINES.ORDERED_QUANTITY > 0
AND ITEMS.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND ITEMS.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND LINES.ORG_ID = HEADER.ORG_ID