APPS.CSI_UTILITY_GRP dependencies on OE_ORDER_LINES_ALL

Line 138: FROM oe_order_lines_all

134: configuration_id
135: INTO l_session_key.session_hdr_id,
136: l_session_key.session_rev_num,
137: l_session_key.session_item_id
138: FROM oe_order_lines_all
139: WHERE line_id = p_line_id;
140:
141: IF csi_interface_pkg.check_macd_processing (
142: p_config_session_key => l_session_key,

Line 212: FROM oe_order_lines_all

208: configuration_id
209: INTO l_session_key.session_hdr_id,
210: l_session_key.session_rev_num,
211: l_session_key.session_item_id
212: FROM oe_order_lines_all
213: WHERE line_id = p_order_line_id;
214:
215: IF csi_interface_pkg.check_macd_processing(
216: p_config_session_key => l_session_key,

Line 456: from oe_order_lines_all

452:
453: BEGIN
454: select inventory_item_id
455: into l_item_id
456: from oe_order_lines_all
457: where line_id = l_source_id;
458:
459: IF p_item_id = l_item_id THEN
460: RETURN(TRUE);

Line 697: oe_order_lines_all ool

693: l_config_keys.session_item_id
694: FROM csi_txn_errors cte,
695: mtl_material_transactions mmt,
696: mtl_unit_transactions mut,
697: oe_order_lines_all ool
698: WHERE mmt.transaction_id = mut.transaction_id
699: AND mmt.transaction_action_id = 1
700: AND mmt.transaction_source_type_id = 2
701: AND mut.transaction_id = cte.inv_material_transaction_id

Line 758: oe_order_lines_all ool

754: ool.config_rev_nbr config_session_rev_num,
755: ool.configuration_id config_session_item_id
756: FROM mtl_material_transactions mmt,
757: mtl_unit_transactions mut,
758: oe_order_lines_all ool
759: WHERE mmt.transaction_id = mut.transaction_id
760: AND mmt.transaction_id = pc_transaction_id
761: AND mmt.transaction_action_id = 1
762: AND mmt.transaction_source_type_id = 2

Line 1469: oe_order_lines_all oel

1465: oel.line_id,
1466: oeh.order_number,
1467: oel.line_number
1468: FROM oe_order_headers_all oeh,
1469: oe_order_lines_all oel
1470: WHERE oeh.header_id = oel.header_id
1471: AND oel.line_id = pc_line_id;
1472:
1473: r_so_info c_so_info%rowtype;

Line 1632: FROM oe_order_headers_all oh, oe_order_lines_all ol

1628:
1629: -- Check to see if the Order Status is closed for this line.
1630: SELECT oh.flow_status_code
1631: INTO l_order_status
1632: FROM oe_order_headers_all oh, oe_order_lines_all ol
1633: WHERE ol.line_id = r_migrated_recs.source_transaction_id
1634: AND ol.header_id = oh.header_id;
1635:
1636: -- Check OE to see if the Order that this Line is on is Closed. If so then remove the