APPS.OKC_XPRT_OM_INT_PVT dependencies on OE_BLANKET_LINES_ALL

Line 1348: FROM oe_blanket_lines_all

1344: ordered_item_id,
1345: org_id,
1346: inventory_item_id,
1347: sold_to_org_id
1348: FROM oe_blanket_lines_all
1349: WHERE header_id = p_doc_id
1350: AND p_doc_type = G_BSA_DOC_TYPE
1351: AND item_identifier_type <> 'CAT'
1352: AND line_category_code = 'ORDER'

Line 1378: FROM oe_blanket_lines_all

1374: -- Returns non-translatable code eg. 208.05
1375: --
1376: CURSOR c_get_item_categories IS
1377: SELECT ordered_item
1378: FROM oe_blanket_lines_all
1379: WHERE header_id = p_doc_id
1380: AND p_doc_type = G_BSA_DOC_TYPE
1381: AND item_identifier_type = 'CAT'
1382: AND line_category_code = 'ORDER'

Line 1388: -- Note: the inventory_item_id stored in oe_blanket_lines_all and oe_order_lines_all

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

Line 1475: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values

1471: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'45: l_master_org_id: ' || l_master_org_id);
1473: END IF;
1474:
1475: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values
1476: -- against variable codes sent in by calling contrtact expert API
1477:
1478: IF p_line_var_tbl.FIRST IS NOT NULL THEN
1479: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP

Line 1554: -- NOTE: the inventory_item_id stored in oe_blanket_lines_all against the non-INT

1550:
1551: END LOOP;
1552:
1553: -- Get the item categories to which the INT and non-INT items in the BSA belong to
1554: -- NOTE: the inventory_item_id stored in oe_blanket_lines_all against the non-INT
1555: -- items is actually that of the mapped INT item so we can use it directly to get the
1556: -- item category
1557:
1558: FOR c_get_items_rec IN c_get_items LOOP

Line 1716: oe_blanket_lines_all bl

1712: bl.ordered_item_id,
1713: bl.sold_to_org_id
1714: --AK
1715: FROM
1716: oe_blanket_lines_all bl
1717: WHERE
1718: bl.header_id = p_doc_id;
1719:
1720: --

Line 1760: FROM oe_blanket_lines_all

1756: -- Returns non-translatable code eg. 208.05
1757: --
1758: CURSOR c_get_item_categories IS
1759: SELECT ordered_item
1760: FROM oe_blanket_lines_all
1761: WHERE header_id = p_doc_id
1762: AND p_doc_type = G_BSA_DOC_TYPE
1763: AND item_identifier_type = 'CAT'
1764: AND line_category_code = 'ORDER'

Line 1770: -- Note: the inventory_item_id stored in oe_blanket_lines_all and oe_order_lines_all

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