APPS.CSC_SERVICE_KEY_PVT dependencies on RA_CUST_TRX_TYPES_ALL
Line 66: ( SELECT cust_trx_type_id FROM ra_cust_trx_types_all
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 67: WHERE type = 'INV') AND
68: ra.trx_number = l_skey_value;
69:
70: -- Invoice Number -- MOAC