DBA Data[Home] [Help]

APPS.INV_OBJECT_GENEALOGY dependencies on HZ_CUST_ACCOUNTS

Line 807: FROM hz_parties hp, hz_cust_accounts hca ,

803: AND poh.vendor_id = pov.vendor_id;
804: ELSIF p_trx_src_type IN(2, 12) THEN -- SO,RMA
805: SELECT party_name
806: INTO l_trading_partner
807: FROM hz_parties hp, hz_cust_accounts hca ,
808: -- R12 TCA Mandate to replace RA_CUSTOMERS with the above 2
809: oe_order_headers_all sha, oe_order_lines_all sla
810: WHERE sla.line_id = p_trx_src_line_id
811: AND sha.header_id = sla.header_id