[Home] [Help]
1361: ordered_item_id,
1362: org_id,
1363: inventory_item_id,
1364: sold_to_org_id
1365: FROM oe_order_lines_all
1366: WHERE header_id = p_doc_id
1367: AND p_doc_type = G_SO_DOC_TYPE
1368: AND item_identifier_type <> 'CAT'
1369: AND line_category_code = 'ORDER'
1384:
1385:
1386: -- Cursor to retrieve categories to which the INT (internal) and non-INT
1387: -- items in the BSA or Sales Order belong
1388: -- Note: the inventory_item_id stored in oe_blanket_lines_all and oe_order_lines_all
1389: -- against the non-INT item is that of the mapped INT item so we can use it
1390: -- directly to get the item category
1391: --
1392: -- Returns non-translatable code eg. HOSPITAL.MISC
1740: ol.component_number,
1741: ol.shipment_number
1742: --Bug 4768964
1743: FROM
1744: oe_order_lines_all ol
1745: WHERE ol.header_id = p_doc_id;
1746:
1747: l_bsa_line_variables c_get_bsa_line_variables%ROWTYPE;
1748: l_so_line_variables c_get_so_line_variables%ROWTYPE;
1766:
1767:
1768: -- Cursor to retrieve categories to which the INT (internal) and non-INT
1769: -- items in the BSA or Sales Order belong
1770: -- Note: the inventory_item_id stored in oe_blanket_lines_all and oe_order_lines_all
1771: -- against the non-INT item is that of the mapped INT item so we can use it
1772: -- directly to get the item category
1773: --
1774: -- Returns non-translatable code eg. HOSPITAL.MISC