[Home] [Help]
2313: ordered_item_id,
2314: org_id,
2315: inventory_item_id,
2316: sold_to_org_id
2317: FROM oe_blanket_lines_all
2318: WHERE header_id = p_doc_id
2319: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE
2320: AND item_identifier_type <> 'CAT'
2321:
2341: --cursor to retrieve the item categories (CATs) in the BSA
2342: --returns non-translatable code eg. 208.05
2343: CURSOR c_get_item_categories IS
2344: SELECT ordered_item
2345: FROM oe_blanket_lines_all
2346: WHERE header_id = p_doc_id
2347: AND p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE
2348: AND item_identifier_type = 'CAT'
2349:
2361:
2362:
2363:
2364: -- cursor to retrieve categories to which the INT (internal) and non-INT items in the BSA or Sales Order belong
2365: /** Note: the inventory_item_id stored in OE_BLANKET_LINES_ALL OE_ORDER_LINES_ALL against the non-INT item is
2366: that of the mapped INT item so we can use it directly to get the item category **/
2367: -- returns non-translatable code eg. HOSPITAL.MISC
2368: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
2369: cp_inventory_item_id NUMBER) IS
2399: END IF;
2400:
2401:
2402: -- For articles wizard expert: -
2403: -- Query OM tables OE_BLANKET_HEADERS_ALL and OE_BLANKET_LINES_ALL to retrieve values against variable codes sent
2404: -- in by calling articles wizard expert API
2405:
2406: IF p_line_var_tbl.FIRST IS NOT NULL THEN
2407: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP
2488:
2489: END LOOP;
2490:
2491: --get the item categories to which the INT and non-INT items in the BSA belong to
2492: /** note: the inventory_item_id stored in oe_blanket_lines_all against the non-INT items is actually that of the mapped INT
2493: item so we can use it directly to get the item category **/
2494: FOR c_get_items_rec IN c_get_items LOOP
2495:
2496: --get inventory master org