DBA Data[Home] [Help]

APPS.CSC_SERVICE_KEY_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 62: FROM hz_cust_accounts cust_acct, ra_customer_trx_all ra

58:
59: -- Invoice Number
60: CURSOR invoice_num_cur IS
61: SELECT cust_acct.party_id, cust_acct.cust_account_id, customer_trx_id, ra.org_id org_id
62: FROM hz_cust_accounts cust_acct, ra_customer_trx_all ra
63: WHERE cust_acct.cust_account_id = ra.bill_to_customer_id AND
64: ra.complete_flag = 'Y' AND
65: ra.cust_trx_type_id IN
66: ( SELECT cust_trx_type_id FROM ra_cust_trx_types_all