DBA Data[Home] [Help]

APPS.INV_OBJECT_GENEALOGY dependencies on OE_ORDER_HEADERS_ALL

Line 755: oe_order_headers_all sha, oe_order_lines_all sla

751: SELECT party_name
752: INTO l_trading_partner
753: FROM hz_parties hp, hz_cust_accounts hca ,
754: -- R12 TCA Mandate to replace RA_CUSTOMERS with the above 2
755: oe_order_headers_all sha, oe_order_lines_all sla
756: WHERE sla.line_id = p_trx_src_line_id
757: AND sha.header_id = sla.header_id
758: --AND sha.sold_to_org_id = rac.customer_id; As part of R12 TCA changes
759: AND sha.sold_to_org_id = hca.cust_account_id