DBA Data[Home] [Help]

APPS.CSI_RMA_FULFILL_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 51: oe_order_headers_all oeh

47: x_rma_line_rec.source_line_ref_id,
48: x_rma_line_rec.source_header_ref,
49: x_rma_line_rec.source_header_ref_id
50: FROM oe_order_lines_all oel ,
51: oe_order_headers_all oeh
52: WHERE oeh.header_id = oel.header_id
53: AND oel.line_id = p_rma_line_id;
54:
55: EXCEPTION

Line 180: l_rma_header_rec oe_order_headers_all%rowtype;

176:
177: l_party_site_id number;
178:
179: l_rma_line_rec oe_order_lines_all%rowtype;
180: l_rma_header_rec oe_order_headers_all%rowtype;
181:
182: l_processing_status varchar2(30);
183:
184: l_found boolean := FALSE;

Line 246: FROM oe_order_lines_all oel, oe_order_headers_all oeh

242: l_rma_line_rec.item_type_code, l_rma_line_rec.shippable_flag,
243: l_rma_line_rec.org_id, l_rma_line_rec.ordered_quantity,
244: l_rma_line_rec.fulfilled_quantity, l_rma_line_rec.fulfillment_date,
245: l_rma_line_rec.line_category_code
246: FROM oe_order_lines_all oel, oe_order_headers_all oeh
247: WHERE line_id = p_rma_line_id
248: AND oel.header_id = oeh.header_id;
249: EXCEPTION
250: WHEN no_data_found THEN