DBA Data[Home] [Help]

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 2140: oe_order_lines_all oel

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

Line 2150: -- oe_order_lines_all oel

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

Line 4143: oe_order_lines_all oel

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