APPS.FV_SF1081_TRANSACTION dependencies on RA_BATCHES

Line 450: FROM RA_BATCHES RB

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
449: (SELECT BATCH_ID
450: FROM RA_BATCHES RB
451: WHERE RB.BATCH_ID = RCT.BATCH_ID
452: AND RB.BATCH_ID = NVL( parm_batch ,RB.BATCH_ID)))
453: OR
454: (parm_batch is null and NVL(BATCH_ID,'99') LIKE DECODE( parm_print_choice ,'SEL','99','NEW','99')))

Line 570: FROM ra_batches

566: (SELECT customer_trx_id
567: FROM ra_customer_trx
568: WHERE batch_id IN
569: (SELECT batch_id
570: FROM ra_batches
571: WHERE batch_id = DECODE(parm_batch,null,BATCH_ID,parm_batch))))
572: OR (parm_batch is null and (NVL(BATCH_ID,'99') LIKE DECODE(parm_print_choice,'SEL','99','NEW','99'))))
573: AND rct.customer_trx_id IN
574: (SELECT rct.customer_trx_id