[Home] [Help]
1098: ordered_item_id,
1099: org_id,
1100: inventory_item_id,
1101: sold_to_org_id
1102: FROM oe_order_lines_all
1103: WHERE header_id = p_doc_id
1104: AND p_doc_type = G_SO_DOC_TYPE
1105: AND item_identifier_type <> 'CAT'
1106: AND line_category_code = 'ORDER'
1121:
1122:
1123: -- Cursor to retrieve categories to which the INT (internal) and non-INT
1124: -- items in the BSA or Sales Order belong
1125: -- Note: the inventory_item_id stored in oe_blanket_lines_all and oe_order_lines_all
1126: -- against the non-INT item is that of the mapped INT item so we can use it
1127: -- directly to get the item category
1128: --
1129: -- Returns non-translatable code eg. HOSPITAL.MISC
1477: ol.component_number,
1478: ol.shipment_number
1479: --Bug 4768964
1480: FROM
1481: oe_order_lines_all ol
1482: WHERE ol.header_id = p_doc_id;
1483:
1484: l_bsa_line_variables c_get_bsa_line_variables%ROWTYPE;
1485: l_so_line_variables c_get_so_line_variables%ROWTYPE;
1503:
1504:
1505: -- Cursor to retrieve categories to which the INT (internal) and non-INT
1506: -- items in the BSA or Sales Order belong
1507: -- Note: the inventory_item_id stored in oe_blanket_lines_all and oe_order_lines_all
1508: -- against the non-INT item is that of the mapped INT item so we can use it
1509: -- directly to get the item category
1510: --
1511: -- Returns non-translatable code eg. HOSPITAL.MISC