eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_SERVICE_KEY_PVT dependencies on RA_CUSTOMER_TRX

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

Line 73: FROM hz_cust_accounts cust_acct, ra_customer_trx ra

69:
70: -- Invoice Number -- MOAC
71: CURSOR invoice_num_moac_cur IS
72: SELECT cust_acct.party_id, cust_acct.cust_account_id, customer_trx_id, ra.org_id org_id
73: FROM hz_cust_accounts cust_acct, ra_customer_trx ra
74: WHERE cust_acct.cust_account_id = ra.bill_to_customer_id AND
75: ra.complete_flag = 'Y' AND
76: ra.cust_trx_type_id IN
77: ( SELECT cust_trx_type_id FROM ra_cust_trx_types