DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2747: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,

2743: FROM MTL_CUSTOMER_ITEMS MCI,
2744: HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC, (SELECT LOC.COUNTRY,
2745: ACCT_SITE.CUST_ACCT_SITE_ID ADDRESS_ID
2746: FROM HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2747: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
2748: HZ_PARTY_SITES PARTY_SITE
2749: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2750: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
2751: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID