APPS.CSI_INV_ISO_PKG dependencies on OE_ORDER_LINES_ALL

Line 116: oe_order_lines_all oel

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:
120: r_so_info c_so_info%rowtype;

Line 2146: oe_order_lines_all oel

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:
2150: -- CURSOR c_so_info (pc_line_id in NUMBER) is

Line 2156: -- oe_order_lines_all oel

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:
2160: r_so_info c_so_info%rowtype;

Line 4165: oe_order_lines_all oel

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:
4169: r_so_info c_so_info%rowtype;