DBA Data[Home] [Help]

APPS.JA_CN_CR_EXPORT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 78: FROM HZ_PARTIES hp ,HZ_CUST_ACCOUNTS hca

74: SELECT
75: hp.PARTY_NUMBER Customer_Number,
76: hp.PARTY_NAME Customer_Name,
77: hp.PARTY_NAME Customer_Short_Name
78: FROM HZ_PARTIES hp ,HZ_CUST_ACCOUNTS hca
79: ,RA_CUSTOMER_TRX rcta ,RA_CUST_TRX_LINE_GL_DIST_ALL gd
80: WHERE hp.PARTY_ID = hca.PARTY_ID
81: AND hca.CUST_ACCOUNT_ID = rcta.BILL_TO_CUSTOMER_ID
82: AND rcta.CUSTOMER_TRX_ID = gd.CUSTOMER_TRX_ID

Line 96: HZ_CUST_ACCOUNTS CUST,

92: PARTY.PARTY_NAME Customer_Name,
93: PARTY.PARTY_NAME Customer_Short_Name
94: FROM
95: HZ_PARTIES PARTY,
96: HZ_CUST_ACCOUNTS CUST,
97: AR_CASH_RECEIPTS_ALL CR,
98: AR_CASH_RECEIPT_HISTORY_ALL CRH_REM,
99: AR_BATCHES_ALL REM_BAT,
100: AR_BATCHES_ALL BAT,