APPS.OKC_XPRT_OM_INT_PVT dependencies on OE_BLANKET_LINES_ALL

Line 1085: FROM oe_blanket_lines_all

1081: ordered_item_id,
1082: org_id,
1083: inventory_item_id,
1084: sold_to_org_id
1085: FROM oe_blanket_lines_all
1086: WHERE header_id = p_doc_id
1087: AND p_doc_type = G_BSA_DOC_TYPE
1088: AND item_identifier_type <> 'CAT'
1089: AND line_category_code = 'ORDER'

Line 1115: FROM oe_blanket_lines_all

1111: -- Returns non-translatable code eg. 208.05
1112: --
1113: CURSOR c_get_item_categories IS
1114: SELECT ordered_item
1115: FROM oe_blanket_lines_all
1116: WHERE header_id = p_doc_id
1117: AND p_doc_type = G_BSA_DOC_TYPE
1118: AND item_identifier_type = 'CAT'
1119: AND line_category_code = 'ORDER'

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

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

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

1208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1209: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'45: l_master_org_id: ' || l_master_org_id);
1210: END IF;
1211:
1212: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values
1213: -- against variable codes sent in by calling contrtact expert API
1214:
1215: IF p_line_var_tbl.FIRST IS NOT NULL THEN
1216: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP

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

1287:
1288: END LOOP;
1289:
1290: -- Get the item categories to which the INT and non-INT items in the BSA belong to
1291: -- NOTE: the inventory_item_id stored in oe_blanket_lines_all against the non-INT
1292: -- items is actually that of the mapped INT item so we can use it directly to get the
1293: -- item category
1294:
1295: FOR c_get_items_rec IN c_get_items LOOP

Line 1453: oe_blanket_lines_all bl

1449: bl.ordered_item_id,
1450: bl.sold_to_org_id
1451: --AK
1452: FROM
1453: oe_blanket_lines_all bl
1454: WHERE
1455: bl.header_id = p_doc_id;
1456:
1457: --

Line 1497: FROM oe_blanket_lines_all

1493: -- Returns non-translatable code eg. 208.05
1494: --
1495: CURSOR c_get_item_categories IS
1496: SELECT ordered_item
1497: FROM oe_blanket_lines_all
1498: WHERE header_id = p_doc_id
1499: AND p_doc_type = G_BSA_DOC_TYPE
1500: AND item_identifier_type = 'CAT'
1501: AND line_category_code = 'ORDER'

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

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