DBA Data[Home] [Help]

APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 1782: JAI_CMN_CUS_ADDRESSES JICA,

1778: ,0)
1779: ,0)) CREDIT_AVAILED_ON_INPUTS_CUST
1780: FROM
1781: JAI_CMN_RG_23AC_II_TRXS JIRP,
1782: JAI_CMN_CUS_ADDRESSES JICA,
1783: HZ_CUST_ACCT_SITES_ALL HZCAS,
1784: HZ_CUST_SITE_USES_ALL HZCSU
1785: WHERE HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID
1786: AND JICA.ADDRESS_ID = HZCSU.CUST_ACCT_SITE_ID

Line 2047: JAI_CMN_CUS_ADDRESSES JICA,

2043: ,0)
2044: FROM
2045: JAI_CMN_RG_OTHERS JRO,
2046: JAI_CMN_RG_23AC_II_TRXS RG23,
2047: JAI_CMN_CUS_ADDRESSES JICA,
2048: HZ_CUST_ACCT_SITES_ALL HZCAS,
2049: HZ_CUST_SITE_USES_ALL HZCSU
2050: WHERE HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID
2051: AND JICA.ADDRESS_ID = HZCSU.CUST_ACCT_SITE_ID

Line 2675: JAI_CMN_CUS_ADDRESSES JICA,

2671: ,0)
2672: FROM
2673: JAI_CMN_RG_OTHERS JRO,
2674: JAI_CMN_RG_23AC_II_TRXS RG23,
2675: JAI_CMN_CUS_ADDRESSES JICA,
2676: HZ_CUST_ACCT_SITES_ALL HZCAS,
2677: HZ_CUST_SITE_USES_ALL HZCSU
2678: WHERE HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID
2679: AND JICA.ADDRESS_ID = HZCSU.CUST_ACCT_SITE_ID