APPS.FV_SF1081_TRANSACTION dependencies on RA_CUST_TRX_TYPES

Line 494: FROM RA_CUST_TRX_TYPES RCTT

490: WHERE HCP.CUST_ACCOUNT_ID = RCT.BILL_TO_CUSTOMER_ID
491: AND HCP.PROFILE_CLASS_ID = NVL(parm_cust_profile_class_id , HCP.PROFILE_CLASS_ID))
492: AND RCT.CUST_TRX_TYPE_ID IN
493: (SELECT CUST_TRX_TYPE_ID
494: FROM RA_CUST_TRX_TYPES RCTT
495: WHERE RCTT.CUST_TRX_TYPE_ID = RCT.CUST_TRX_TYPE_ID
496: AND ( RCTT.TYPE LIKE NVL(parm_transaction_class ,'%')
497: OR RCTT.CUST_TRX_TYPE_ID = NVL(parm_transaction_type, RCTT.CUST_TRX_TYPE_ID)))
498: AND ((RCT.BATCH_ID IN

Line 591: FROM ra_cust_trx_types

587: DECODE(parm_cust_profile_class_id,null,profile_class_id,
588: parm_cust_profile_class_id))
589: AND rct.cust_trx_type_id IN
590: ((SELECT cust_trx_type_id
591: FROM ra_cust_trx_types
592: WHERE type LIKE NVL(parm_transaction_class,'%'))
593: INTERSECT
594: (SELECT cust_trx_type_id
595: FROM ra_cust_trx_types

Line 595: FROM ra_cust_trx_types

591: FROM ra_cust_trx_types
592: WHERE type LIKE NVL(parm_transaction_class,'%'))
593: INTERSECT
594: (SELECT cust_trx_type_id
595: FROM ra_cust_trx_types
596: WHERE cust_trx_type_id = DECODE(parm_transaction_type,null,
597: cust_trx_type_id,parm_transaction_type)))
598: AND (rct.trx_number BETWEEN NVL(parm_trans_num_low,'0')
599: AND NVL(parm_trans_num_high,'zzzzzzzzzzzzzzzzzzzz'))