DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on HZ_PARTIES

Line 5586: HZ_PARTIES HP ,

5582: WHERE NOT EXISTS ( SELECT 'Y'
5583: FROM
5584: AP_SUPPLIER_CONTACTS PVC ,
5585: AP_SUPPLIER_SITES_ALL PVS ,
5586: HZ_PARTIES HP ,
5587: HZ_RELATIONSHIPS HPR ,
5588: HZ_PARTY_SITES HPS ,
5589: HZ_ORG_CONTACTS HOC ,
5590: HZ_PARTIES HP2 ,

Line 5590: HZ_PARTIES HP2 ,

5586: HZ_PARTIES HP ,
5587: HZ_RELATIONSHIPS HPR ,
5588: HZ_PARTY_SITES HPS ,
5589: HZ_ORG_CONTACTS HOC ,
5590: HZ_PARTIES HP2 ,
5591: AP_SUPPLIERS APS,
5592: PO_HEADERS_ALL POH
5593: WHERE PVC.PER_PARTY_ID = HP.PARTY_ID
5594: AND PVC.REL_PARTY_ID = HP2.PARTY_ID

Line 7879: HZ_PARTIES HP ,

7875: WHERE NOT EXISTS ( SELECT 'Y'
7876: FROM
7877: AP_SUPPLIER_CONTACTS PVC ,
7878: AP_SUPPLIER_SITES_ALL PVS ,
7879: HZ_PARTIES HP ,
7880: HZ_RELATIONSHIPS HPR ,
7881: HZ_PARTY_SITES HPS ,
7882: HZ_ORG_CONTACTS HOC ,
7883: HZ_PARTIES HP2 ,

Line 7883: HZ_PARTIES HP2 ,

7879: HZ_PARTIES HP ,
7880: HZ_RELATIONSHIPS HPR ,
7881: HZ_PARTY_SITES HPS ,
7882: HZ_ORG_CONTACTS HOC ,
7883: HZ_PARTIES HP2 ,
7884: AP_SUPPLIERS APS,
7885: po_headers_gt POH
7886: WHERE PVC.PER_PARTY_ID = HP.PARTY_ID
7887: AND PVC.REL_PARTY_ID = HP2.PARTY_ID