DBA Data[Home] [Help]

APPS.JA_JAIN23D_XMLP_PKG dependencies on HZ_PARTY_SITES

Line 18: HZ_PARTY_SITES HZPS,

14: HZ_PARTIES E,
15: HZ_CUST_ACCOUNTS HZCA,
16: JAI_CMN_CUS_ADDRESSES F,
17: HZ_LOCATIONS G,
18: HZ_PARTY_SITES HZPS,
19: HZ_CUST_ACCT_SITES_ALL HZCAS,
20: HZ_CUST_SITE_USES_ALL H
21: WHERE E.PARTY_ID = HZCA.PARTY_ID
22: AND HZCA.CUST_ACCOUNT_ID = F.CUSTOMER_ID

Line 101: HZ_PARTY_SITES HZPS,

97: HZ_PARTIES E,
98: HZ_CUST_ACCOUNTS HZCA,
99: JAI_CMN_CUS_ADDRESSES F,
100: HZ_LOCATIONS G,
101: HZ_PARTY_SITES HZPS,
102: HZ_CUST_ACCT_SITES_ALL HZCAS,
103: HZ_CUST_SITE_USES_ALL H
104: WHERE HZCA.CUST_ACCOUNT_ID = P_CUSTOMER_ID
105: AND E.PARTY_ID = HZCA.PARTY_ID

Line 209: HZ_PARTY_SITES HZPS,

205: HZ_PARTIES E,
206: HZ_CUST_ACCOUNTS HZCA,
207: JAI_CMN_CUS_ADDRESSES F,
208: HZ_LOCATIONS G,
209: HZ_PARTY_SITES HZPS,
210: HZ_CUST_ACCT_SITES_ALL HZCAS,
211: HZ_CUST_SITE_USES_ALL H
212: WHERE E.PARTY_ID = HZCA.PARTY_ID
213: AND HZCA.CUST_ACCOUNT_ID = F.CUSTOMER_ID

Line 468: HZ_PARTY_SITES HZPS,

464: HZ_PARTIES E,
465: HZ_CUST_ACCOUNTS HZCA,
466: JAI_CMN_CUS_ADDRESSES F,
467: HZ_LOCATIONS G,
468: HZ_PARTY_SITES HZPS,
469: HZ_CUST_ACCT_SITES_ALL HZCAS,
470: HZ_CUST_SITE_USES_ALL H
471: WHERE E.PARTY_ID = HZCA.CUST_ACCOUNT_ID
472: AND HZCA.CUST_ACCOUNT_ID = F.CUSTOMER_ID