[Home] [Help]
2322: ordered_item_id,
2323: org_id,
2324: inventory_item_id,
2325: sold_to_org_id
2326: FROM oe_blanket_lines_all
2327: WHERE header_id = p_doc_id
2328: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE
2329: AND item_identifier_type <> 'CAT'
2330:
2350: --cursor to retrieve the item categories (CATs) in the BSA
2351: --returns non-translatable code eg. 208.05
2352: CURSOR c_get_item_categories IS
2353: SELECT ordered_item
2354: FROM oe_blanket_lines_all
2355: WHERE header_id = p_doc_id
2356: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE
2357: AND item_identifier_type = 'CAT'
2358:
2370:
2371:
2372:
2373: -- cursor to retrieve categories to which the INT (internal) and non-INT items in the BSA or Sales Order belong
2374: /** Note: the inventory_item_id stored in OE_BLANKET_LINES_ALL OE_ORDER_LINES_ALL against the non-INT item is
2375: that of the mapped INT item so we can use it directly to get the item category **/
2376: -- returns non-translatable code eg. HOSPITAL.MISC
2377: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
2378: cp_inventory_item_id NUMBER) IS
2408: END IF;
2409:
2410:
2411: -- For articles wizard expert: -
2412: -- Query OM tables OE_BLANKET_HEADERS_ALL and OE_BLANKET_LINES_ALL to retrieve values against variable codes sent
2413: -- in by calling articles wizard expert API
2414:
2415: IF p_line_var_tbl.FIRST IS NOT NULL THEN
2416: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP
2497:
2498: END LOOP;
2499:
2500: --get the item categories to which the INT and non-INT items in the BSA belong to
2501: /** note: the inventory_item_id stored in oe_blanket_lines_all against the non-INT items is actually that of the mapped INT
2502: item so we can use it directly to get the item category **/
2503: FOR c_get_items_rec IN c_get_items LOOP
2504:
2505: --get inventory master org