APPS.CSI_UTILITY_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 1468: FROM oe_order_headers_all oeh,

1464: SELECT oeh.header_id,
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:

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