DBA Data[Home] [Help]

APPS.JA_CN_CR_EXPORT_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 79: ,RA_CUSTOMER_TRX rcta ,RA_CUST_TRX_LINE_GL_DIST_ALL gd

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
83: AND rcta.legal_entity_id = pn_legal_entity_id