APPS.CSI_RMA_RECEIPT_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 387: oe_order_headers_all oeh

383: x_partner_order_rec.END_CUSTOMER_CONTACT_ID,
384: x_partner_order_rec.END_CUSTOMER_SITE_USE_ID,
385: x_partner_order_rec.SOLD_TO_SITE_USE_ID
386: FROM oe_order_lines_all oel,
387: oe_order_headers_all oeh
388: WHERE oel.line_id = l_rma_line_id
389: AND oeh.header_id = oel.header_id;
390:
391: IF x_partner_order_rec.IB_OWNER = 'END_CUSTOMER' THEN

Line 476: FROM oe_order_lines_all oel, oe_order_headers_all oeh

472: INTO x_src_order_rec.customer_account_id,
473: l_ship_to_org,
474: l_invoice_to_org,
475: x_src_order_rec.original_order_qty
476: FROM oe_order_lines_all oel, oe_order_headers_all oeh
477: WHERE line_id = x_src_order_rec.rma_line_id
478: AND oeh.header_id = oel.header_id;
479:
480: debug(' Original Order Line ID: '||x_src_order_rec.original_order_line_id);

Line 3828: FROM oe_order_headers_all ooh,

3824: INTO x_mtl_trx_type.source_header_id,
3825: x_mtl_trx_type.source_header_ref,
3826: x_mtl_trx_type.source_line_id,
3827: x_mtl_trx_type.source_line_ref
3828: FROM oe_order_headers_all ooh,
3829: oe_order_lines_all ool
3830: WHERE ool.line_id = x_mtl_trx_type.source_line_id
3831: AND ool.header_id = ooh.header_id;
3832: