APPS.CSI_RMA_RECEIPT_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 388: oe_order_headers_all oeh

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

Line 477: FROM oe_order_lines_all oel, oe_order_headers_all oeh

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

Line 3867: FROM oe_order_headers_all ooh,

3863: INTO x_mtl_trx_type.source_header_id,
3864: x_mtl_trx_type.source_header_ref,
3865: x_mtl_trx_type.source_line_id,
3866: x_mtl_trx_type.source_line_ref
3867: FROM oe_order_headers_all ooh,
3868: oe_order_lines_all ool
3869: WHERE ool.line_id = x_mtl_trx_type.source_line_id
3870: AND ool.header_id = ooh.header_id;
3871: