DBA Data[Home] [Help]

APPS.FV_SF1080_TRANSACTION dependencies on RA_CUST_TRX_TYPES

Line 278: FROM RA_CUST_TRX_TYPES

274: WHERE profile_class_id = decode(parm_cust_profile_class_id,null,
275: profile_class_id,parm_cust_profile_class_id))
276: AND rct.cust_trx_type_id IN
277: ((SELECT CUST_TRX_TYPE_ID
278: FROM RA_CUST_TRX_TYPES
279: WHERE TYPE LIKE NVL(parm_transaction_class,'%'))
280: intersect
281: (SELECT CUST_TRX_TYPE_ID
282: FROM RA_CUST_TRX_TYPES

Line 282: FROM RA_CUST_TRX_TYPES

278: FROM RA_CUST_TRX_TYPES
279: WHERE TYPE LIKE NVL(parm_transaction_class,'%'))
280: intersect
281: (SELECT CUST_TRX_TYPE_ID
282: FROM RA_CUST_TRX_TYPES
283: WHERE CUST_TRX_TYPE_ID = decode(parm_transaction_type,null,
284: CUST_TRX_TYPE_ID,parm_transaction_type)))
285: AND (rct.trx_number between nvl(parm_trans_num_low,'0')
286: and nvl(parm_trans_num_high,'ZZZZZZZZZZZZZZZZZZZZ'))