APPS.CSC_SERVICE_KEY_PVT dependencies on RA_CUST_TRX_TYPES

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

Line 77: ( SELECT cust_trx_type_id FROM ra_cust_trx_types

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
78: WHERE type = 'INV') AND
79: ra.trx_number = l_skey_value;
80:
81: -- Order Number