APPS.CSI_DIAGNOSTICS_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 8816: oe_order_headers_all oeh

8812:
8813: SELECT nvl(oel.sold_to_org_id, oeh.sold_to_org_id)
8814: INTO l_owner_account_id
8815: FROM oe_order_lines_all oel,
8816: oe_order_headers_all oeh
8817: WHERE oel.line_id = l_rma_line_id
8818: AND oeh.header_id = oel.header_id;
8819:
8820: SELECT party_id

Line 15166: oe_order_headers_all hdr

15162: INTO l_customer_id,
15163: l_rma_num,
15164: l_rma_line_num
15165: FROM oe_order_lines_all line,
15166: oe_order_headers_all hdr
15167: WHERE line.line_id = csi_rec.trx_source_line_id
15168: AND hdr.header_id = line.header_id;
15169:
15170: l_customer_name := get_customer(l_customer_id, null);