DBA Data[Home] [Help]

APPS.CE_CEXAVBCH_XMLP_PKG dependencies on CE_200_TRANSACTIONS_V

Line 103: CE_200_TRANSACTIONS_V A

99: INTO
100: C_BATCH_AMOUNT
101: ,C_BATCH_BANK_ACCOUNT_AMOUNT
102: FROM
103: CE_200_TRANSACTIONS_V A
104: WHERE TRX_TYPE in ( 'PAYMENT' , 'REFUND' )
105: AND BATCH_ID = BATCH_ID_1
106: AND NVL(STATUS
107: ,'NEGOTIABLE') <> 'VOIDED';

Line 150: CE_200_TRANSACTIONS_V

146: INTO
147: C_BATCH_AMOUNT
148: ,C_BATCH_BANK_ACCOUNT_AMOUNT
149: FROM
150: CE_200_TRANSACTIONS_V
151: WHERE TRX_TYPE in ( 'PAYMENT' , 'REFUND' )
152: AND BATCH_ID = BATCH_ID_1
153: AND NVL(STATUS
154: ,'NEGOTIABLE') <> 'VOIDED';

Line 197: CE_200_TRANSACTIONS_V

193: INTO
194: C_BATCH_AMOUNT
195: ,C_BATCH_BANK_ACCOUNT_AMOUNT
196: FROM
197: CE_200_TRANSACTIONS_V
198: WHERE TRX_TYPE in ( 'PAYMENT' , 'REFUND' )
199: AND BATCH_ID = BATCH_ID_1
200: AND NVL(STATUS
201: ,'NEGOTIABLE') <> 'VOIDED';