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_ALL

Line 2882: l_reclass_receipt_number ar_cash_receipts_all.receipt_number%TYPE;

2878:
2879: --Added for reclassification changes
2880: l_void_check_number ap_checks_all.void_check_number%TYPE;
2881: l_voided_reclassified_payment VARCHAR2(1);
2882: l_reclass_receipt_number ar_cash_receipts_all.receipt_number%TYPE;
2883: l_receipt_reclassified VARCHAR2(1);
2884: l_ar_reclass_attribute VARCHAR2(15);
2885: sql_stmt VARCHAR2(500);
2886: sql_stmt1 VARCHAR2(500);

Line 3412: FROM Ar_Cash_Receipts_All

3408: ELSIF (l_cash_receipt_id IS NOT NULL) THEN
3409: BEGIN
3410: SELECT 'Y'
3411: INTO l_exists
3412: FROM Ar_Cash_Receipts_All
3413: WHERE cash_receipt_id = to_number(l_cash_receipt_id);
3414: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CASH RECEIPT ID EXISTS');
3416: END IF;

Line 3529: FROM ar_cash_receipts_all

3525: -- get the document number
3526: BEGIN
3527: SELECT receipt_number
3528: INTO l_document_number
3529: FROM ar_cash_receipts_all
3530: WHERE cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3531: EXCEPTION WHEN NO_DATA_FOUND THEN
3532: SELECT SUBSTR(name,1,50)
3533: INTO l_document_number

Line 3662: FROM ar_cash_receipts_all

3658: END IF; -- rev check
3659: BEGIN
3660: SELECT DECODE(l_exists,'Y',reversal_date,receipt_date)
3661: INTO l_accomplish_date
3662: FROM ar_cash_receipts_all
3663: WHERE cash_receipt_id = l_cash_receipt_id;
3664: EXCEPTION
3665: WHEN OTHERS THEN
3666: error_buf := SQLERRM|| '- Error while deriving the accomplish date'

Line 3679: FROM Ar_Cash_Receipts_All

3675: END IF;
3676: BEGIN
3677: SELECT remit_bank_acct_use_id
3678: INTO vg_bank_acct_id
3679: FROM Ar_Cash_Receipts_All
3680: WHERE cash_receipt_id = TO_NUMBER(l_cash_receipt_id);
3681: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3682: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND THE BANK ACCOUNT ID');
3683: END IF;

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

3725: IF (l_ia_flag = 'N' AND l_ar_reclass_attribute IS NOT NULL
3726: AND l_cash_receipt_id IS NOT NULL) THEN
3727: BEGIN
3728: sql_stmt1:= 'SELECT ACR.' || l_ar_reclass_attribute ||
3729: ' FROM AR_CASH_RECEIPTS_ALL ACR WHERE ACR.cash_receipt_id = '
3730: || l_cash_receipt_id;
3731: l_reclass_receipt_number := NULL;
3732: EXECUTE IMMEDIATE sql_stmt1 INTO l_reclass_receipt_number ;
3733: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4548: END;
4549: ELSIF l_je_source = 'Receivables' AND l_cash_receipt_id IS NOT NULL AND l_ar_reclass_attribute IS NOT NULL THEN
4550: BEGIN
4551: sql_stmt1:= 'SELECT ACR.' || l_ar_reclass_attribute ||
4552: ' FROM AR_CASH_RECEIPTS_ALL ACR WHERE ACR.cash_receipt_id = '||l_cash_receipt_id;
4553: EXECUTE IMMEDIATE sql_stmt1 INTO l_reclass_receipt_number ;
4554: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4555: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Reclass Receipt Number: '|| l_reclass_receipt_number );
4556: END IF;

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

4558: WHEN NO_DATA_FOUND THEN
4559: l_reclass_receipt_number:=NULL;
4560: END;
4561: BEGIN
4562: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Cash_Receipt_History_All ah
4563: where ac.cash_receipt_id = ah.cash_receipt_id
4564: and ah.cash_receipt_history_id = '|| l_cash_receipt_hist_id ||
4565: ' and ah.STATUS= ''REVERSED'' '||
4566: ' AND ah.CURRENT_RECORD_FLAG = ''Y'' '||

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

4563: where ac.cash_receipt_id = ah.cash_receipt_id
4564: and ah.cash_receipt_history_id = '|| l_cash_receipt_hist_id ||
4565: ' and ah.STATUS= ''REVERSED'' '||
4566: ' AND ah.CURRENT_RECORD_FLAG = ''Y'' '||
4567: ' and exists (SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL AC2 '||
4568: ' WHERE AC2.' || l_ar_reclass_attribute ||
4569: ' = ' || '''' || l_document_number || '''' || ' )' ;
4570: EXECUTE IMMEDIATE sql_stmt INTO l_receipt_reclassified ;
4571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4577: l_exists := 'M';
4578: END;
4579: IF(l_exists = 'M') AND (l_je_category = 'Misc Receipts') THEN
4580: BEGIN
4581: sql_stmt:='SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL ac, Ar_Misc_Cash_Distributions_All ah
4582: where ac.cash_receipt_id = ah.cash_receipt_id
4583: and ah.misc_cash_distribution_id = '|| l_cash_receipt_hist_id ||
4584: ' and ah.cash_receipt_id = '||l_cash_receipt_id||
4585: ' and ah.created_from= ''ARP_REVERSE_RECEIPT.REVERSE'' '||

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

4582: where ac.cash_receipt_id = ah.cash_receipt_id
4583: and ah.misc_cash_distribution_id = '|| l_cash_receipt_hist_id ||
4584: ' and ah.cash_receipt_id = '||l_cash_receipt_id||
4585: ' and ah.created_from= ''ARP_REVERSE_RECEIPT.REVERSE'' '||
4586: ' and exists (SELECT ''Y'' FROM AR_CASH_RECEIPTS_ALL AC2 '||
4587: ' WHERE AC2.' || l_ar_reclass_attribute ||
4588: ' = ' || '''' || l_document_number || '''' || ' )' ;
4589: EXECUTE IMMEDIATE sql_stmt INTO l_receipt_reclassified ;
4590: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN