APPS.FV_SF1081_TRANSACTION dependencies on RA_CUST_TRX_TYPES

Line 444: FROM RA_CUST_TRX_TYPES RCTT

440: WHERE HCP.CUST_ACCOUNT_ID = RCT.BILL_TO_CUSTOMER_ID
441: AND HCP.PROFILE_CLASS_ID = NVL(parm_cust_profile_class_id , HCP.PROFILE_CLASS_ID))
442: AND RCT.CUST_TRX_TYPE_ID IN
443: (SELECT CUST_TRX_TYPE_ID
444: FROM RA_CUST_TRX_TYPES RCTT
445: WHERE RCTT.CUST_TRX_TYPE_ID = RCT.CUST_TRX_TYPE_ID
446: AND ( RCTT.TYPE LIKE NVL(parm_transaction_class ,'%')
447: OR RCTT.CUST_TRX_TYPE_ID = NVL(parm_transaction_type, RCTT.CUST_TRX_TYPE_ID)))
448: AND ((RCT.BATCH_ID IN

Line 541: FROM ra_cust_trx_types

537: DECODE(parm_cust_profile_class_id,null,profile_class_id,
538: parm_cust_profile_class_id))
539: AND rct.cust_trx_type_id IN
540: ((SELECT cust_trx_type_id
541: FROM ra_cust_trx_types
542: WHERE type LIKE NVL(parm_transaction_class,'%'))
543: INTERSECT
544: (SELECT cust_trx_type_id
545: FROM ra_cust_trx_types

Line 545: FROM ra_cust_trx_types

541: FROM ra_cust_trx_types
542: WHERE type LIKE NVL(parm_transaction_class,'%'))
543: INTERSECT
544: (SELECT cust_trx_type_id
545: FROM ra_cust_trx_types
546: WHERE cust_trx_type_id = DECODE(parm_transaction_type,null,
547: cust_trx_type_id,parm_transaction_type)))
548: AND (rct.trx_number BETWEEN NVL(parm_trans_num_low,'0')
549: AND NVL(parm_trans_num_high,'zzzzzzzzzzzzzzzzzzzz'))