eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_SF224_TRANSACTIONS dependencies on AR_CASH_RECEIPTS

Line 2754: l_reclass_receipt_number ar_cash_receipts_all.receipt_number%TYPE;

2750:
2751: --Added for reclassification changes
2752: l_void_check_number ap_checks_all.void_check_number%TYPE;
2753: l_voided_reclassified_payment VARCHAR2(1);
2754: l_reclass_receipt_number ar_cash_receipts_all.receipt_number%TYPE;
2755: l_receipt_reclassified VARCHAR2(1);
2756: l_ar_reclass_attribute VARCHAR2(15);
2757: sql_stmt VARCHAR2(500);
2758: sql_stmt1 VARCHAR2(500);

Line 3277: FROM Ar_Cash_Receipts_All

3273: ELSIF (l_cash_receipt_id IS NOT NULL) THEN
3274: BEGIN
3275: SELECT 'Y'
3276: INTO l_exists
3277: FROM Ar_Cash_Receipts_All
3278: WHERE cash_receipt_id = to_number(l_cash_receipt_id);
3279: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3280: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT ID EXISTS');
3281: END IF;

Line 3394: FROM ar_cash_receipts_all

3390: -- get the document number
3391: BEGIN
3392: SELECT receipt_number
3393: INTO l_document_number
3394: FROM ar_cash_receipts_all
3395: WHERE cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3396: EXCEPTION WHEN NO_DATA_FOUND THEN
3397: SELECT SUBSTR(name,1,50)
3398: INTO l_document_number

Line 3527: FROM ar_cash_receipts_all

3523: END IF; -- rev check
3524: BEGIN
3525: SELECT DECODE(l_exists,'Y',reversal_date,receipt_date)
3526: INTO l_accomplish_date
3527: FROM ar_cash_receipts_all
3528: WHERE cash_receipt_id = l_cash_receipt_id;
3529: EXCEPTION
3530: WHEN OTHERS THEN
3531: error_buf := SQLERRM|| '- Error while deriving the accomplish date'

Line 3544: FROM Ar_Cash_Receipts_All

3540: END IF;
3541: BEGIN
3542: SELECT remit_bank_acct_use_id
3543: INTO vg_bank_acct_id
3544: FROM Ar_Cash_Receipts_All
3545: WHERE cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3546: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND THE BANK ACCOUNT ID');
3548: END IF;

Line 3594: ' FROM AR_CASH_RECEIPTS_ALL ACR WHERE ACR.cash_receipt_id = '

3590: IF (l_ia_flag = 'N' AND l_ar_reclass_attribute IS NOT NULL
3591: AND l_cash_receipt_id IS NOT NULL) THEN
3592: BEGIN
3593: sql_stmt1:= 'SELECT ACR.' || l_ar_reclass_attribute ||
3594: ' FROM AR_CASH_RECEIPTS_ALL ACR WHERE ACR.cash_receipt_id = '
3595: || l_cash_receipt_id;
3596: l_reclass_receipt_number := NULL;
3597: EXECUTE IMMEDIATE sql_stmt1 INTO l_reclass_receipt_number ;
3598: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3612: FROM ar_cash_receipts b

3608: SELECT 'x'
3609: INTO l_dummy
3610: FROM fv_interagency_funds_all a
3611: WHERE cash_receipt_id = (SELECT cash_receipt_id
3612: FROM ar_cash_receipts b
3613: WHERE b.receipt_number = l_reclass_receipt_number);
3614: l_ia_flag := 'Y';
3615: l_txn_category := 'I';
3616: l_update_type := 'RECEIPT';

Line 4414: ' FROM AR_CASH_RECEIPTS_ALL ACR WHERE ACR.cash_receipt_id = '||l_cash_receipt_id;

4410: END;
4411: ELSIF l_je_source = 'Receivables' AND l_cash_receipt_id IS NOT NULL AND l_ar_reclass_attribute IS NOT NULL THEN
4412: BEGIN
4413: sql_stmt1:= 'SELECT ACR.' || l_ar_reclass_attribute ||
4414: ' FROM AR_CASH_RECEIPTS_ALL ACR WHERE ACR.cash_receipt_id = '||l_cash_receipt_id;
4415: EXECUTE IMMEDIATE sql_stmt1 INTO l_reclass_receipt_number ;
4416: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4417: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Reclass Receipt Number: '|| l_reclass_receipt_number );
4418: END IF;

Line 4424: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Cash_Receipt_History_All ah

4420: WHEN NO_DATA_FOUND THEN
4421: l_reclass_receipt_number:=NULL;
4422: END;
4423: BEGIN
4424: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Cash_Receipt_History_All ah
4425: where ac.cash_receipt_id = ah.cash_receipt_id
4426: and ah.cash_receipt_history_id = '|| l_cash_receipt_hist_id ||
4427: ' and ah.STATUS= ''REVERSED'' '||
4428: ' AND ah.CURRENT_RECORD_FLAG = ''Y'' '||

Line 4429: ' and exists (SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL AC2 '||

4425: where ac.cash_receipt_id = ah.cash_receipt_id
4426: and ah.cash_receipt_history_id = '|| l_cash_receipt_hist_id ||
4427: ' and ah.STATUS= ''REVERSED'' '||
4428: ' AND ah.CURRENT_RECORD_FLAG = ''Y'' '||
4429: ' and exists (SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL AC2 '||
4430: ' WHERE AC2.' || l_ar_reclass_attribute ||
4431: ' = ' || '''' || l_document_number || '''' || ' )' ;
4432: EXECUTE IMMEDIATE sql_stmt INTO l_receipt_reclassified ;
4433: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4443: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Misc_Cash_Distributions_All ah

4439: l_exists := 'M';
4440: END;
4441: IF(l_exists = 'M') AND (l_je_category = 'Misc Receipts') THEN
4442: BEGIN
4443: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Misc_Cash_Distributions_All ah
4444: where ac.cash_receipt_id = ah.cash_receipt_id
4445: and ah.misc_cash_distribution_id = '|| l_cash_receipt_hist_id ||
4446: ' and ah.cash_receipt_id = '||l_cash_receipt_id||
4447: ' and ah.created_from= ''ARP_REVERSE_RECEIPT.REVERSE'' '||

Line 4448: ' and exists (SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL AC2 '||

4444: where ac.cash_receipt_id = ah.cash_receipt_id
4445: and ah.misc_cash_distribution_id = '|| l_cash_receipt_hist_id ||
4446: ' and ah.cash_receipt_id = '||l_cash_receipt_id||
4447: ' and ah.created_from= ''ARP_REVERSE_RECEIPT.REVERSE'' '||
4448: ' and exists (SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL AC2 '||
4449: ' WHERE AC2.' || l_ar_reclass_attribute ||
4450: ' = ' || '''' || l_document_number || '''' || ' )' ;
4451: EXECUTE IMMEDIATE sql_stmt INTO l_receipt_reclassified ;
4452: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN