DBA Data[Home] [Help]

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 2139: FROM oe_order_headers_all oeh,

2135: SELECT oeh.header_id,
2136: oel.line_id,
2137: oeh.order_number,
2138: oel.line_number
2139: FROM oe_order_headers_all oeh,
2140: oe_order_lines_all oel
2141: WHERE oeh.header_id = oel.header_id
2142: AND oel.line_id = pc_line_id;
2143:

Line 2149: -- FROM oe_order_headers_all oeh,

2145: -- SELECT oeh.header_id,
2146: -- oel.line_id,
2147: -- oeh.order_number,
2148: -- oel.line_number
2149: -- FROM oe_order_headers_all oeh,
2150: -- oe_order_lines_all oel
2151: -- WHERE oeh.header_id = oel.header_id
2152: -- AND oel.source_document_id = pc_line_id;
2153:

Line 4142: FROM oe_order_headers_all oeh,

4138: SELECT oeh.header_id,
4139: oel.line_id,
4140: oeh.order_number,
4141: oel.line_number
4142: FROM oe_order_headers_all oeh,
4143: oe_order_lines_all oel
4144: WHERE oeh.header_id = oel.header_id
4145: AND oel.line_id = pc_line_id;
4146: