DBA Data[Home] [Help]

APPS.AR_CMGT_PARTY_SEARCH dependencies on HZ_PARTY_SITES

Line 94: HZ_PARTY_SITES PARTY_SITE,

90: HZ_PARTIES HZP,
91: HZ_CUST_ACCOUNTS CA,
92: HZ_CUST_ACCT_SITES CAS,
93: HZ_LOCATIONS LOC,
94: HZ_PARTY_SITES PARTY_SITE,
95: FND_TERRITORIES_VL TERR
96: WHERE SEARCH_CONTEXT_ID = p_context_id
97: AND GT.PARTY_ID = HZP.PARTY_ID
98: AND GT.PARTY_ID = CA.PARTY_ID(+)