APPS.FV_SF1081_TRANSACTION dependencies on RA_BATCHES

Line 500: FROM RA_BATCHES RB

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
499: (SELECT BATCH_ID
500: FROM RA_BATCHES RB
501: WHERE RB.BATCH_ID = RCT.BATCH_ID
502: AND RB.BATCH_ID = NVL( parm_batch ,RB.BATCH_ID)))
503: OR
504: (parm_batch is null and NVL(BATCH_ID,'99') LIKE DECODE( parm_print_choice ,'SEL','99','NEW','99')))

Line 620: FROM ra_batches

616: (SELECT customer_trx_id
617: FROM ra_customer_trx
618: WHERE batch_id IN
619: (SELECT batch_id
620: FROM ra_batches
621: WHERE batch_id = DECODE(parm_batch,null,BATCH_ID,parm_batch))))
622: OR (parm_batch is null and (NVL(BATCH_ID,'99') LIKE DECODE(parm_print_choice,'SEL','99','NEW','99'))))
623: AND rct.customer_trx_id IN
624: (SELECT rct.customer_trx_id