DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PUB dependencies on HZ_ORG_CONTACTS

Line 585: FROM hz_org_contacts org_con

581: AND rel.subject_table_name = 'HZ_PARTIES'
582: AND rel.object_table_name = 'HZ_PARTIES'
583: AND rel.relationship_id IN
584: (SELECT party_relationship_id
585: FROM hz_org_contacts org_con
586: WHERE rel.relationship_id =
587: org_con.party_relationship_id
588: AND org_con.status ='A' )
589: AND party5.party_id = l_customer_id --customer id on user