DBA Data[Home] [Help]

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 15155: oe_order_headers_all hdr

15151: INTO l_customer_id,
15152: l_rma_num,
15153: l_rma_line_num
15154: FROM oe_order_lines_all line,
15155: oe_order_headers_all hdr
15156: WHERE line.line_id = csi_rec.trx_source_line_id
15157: AND hdr.header_id = line.header_id;
15158:
15159: l_customer_name := get_customer(l_customer_id, null);