APPS.CSI_INV_ISO_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 115: FROM oe_order_headers_all oeh,

111: SELECT oeh.header_id,
112: oel.line_id,
113: oeh.order_number,
114: oel.line_number
115: FROM oe_order_headers_all oeh,
116: oe_order_lines_all oel
117: WHERE oeh.header_id = oel.header_id
118: AND oel.line_id = pc_line_id;
119:

Line 2145: FROM oe_order_headers_all oeh,

2141: SELECT oeh.header_id,
2142: oel.line_id,
2143: oeh.order_number,
2144: oel.line_number
2145: FROM oe_order_headers_all oeh,
2146: oe_order_lines_all oel
2147: WHERE oeh.header_id = oel.header_id
2148: AND oel.line_id = pc_line_id;
2149:

Line 2155: -- FROM oe_order_headers_all oeh,

2151: -- SELECT oeh.header_id,
2152: -- oel.line_id,
2153: -- oeh.order_number,
2154: -- oel.line_number
2155: -- FROM oe_order_headers_all oeh,
2156: -- oe_order_lines_all oel
2157: -- WHERE oeh.header_id = oel.header_id
2158: -- AND oel.source_document_id = pc_line_id;
2159:

Line 4164: FROM oe_order_headers_all oeh,

4160: SELECT oeh.header_id,
4161: oel.line_id,
4162: oeh.order_number,
4163: oel.line_number
4164: FROM oe_order_headers_all oeh,
4165: oe_order_lines_all oel
4166: WHERE oeh.header_id = oel.header_id
4167: AND oel.line_id = pc_line_id;
4168: