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.

[Home] [Help]

APPS.AR_IREC_APPLY_CREDITS dependencies on AR_IREC_APPLY_CREDIT_GT

Line 172: INSERT INTO ar_irec_apply_credit_gt

168: FOR trx IN transaction_list(p_customer_id,
169: p_customer_site_use_id,
170: p_currency_code )
171: LOOP
172: INSERT INTO ar_irec_apply_credit_gt
173: (
174: CUSTOMER_ID,
175: CUSTOMER_SITE_USE_ID,
176: ACCOUNT_NUMBER,

Line 511: INSERT INTO ar_irec_apply_credit_gt

507: l_pay_for_cust_id := l_customer_id;
508: l_pay_for_cust_site_id := l_customer_site_use_id;
509: end if;
510:
511: INSERT INTO ar_irec_apply_credit_gt
512: (
513: CUSTOMER_ID,
514: CUSTOMER_SITE_USE_ID,
515: ACCOUNT_NUMBER,

Line 709: DELETE FROM ar_irec_apply_credit_gt

705: IF (PG_DEBUG = 'Y') THEN
706: arp_standard.debug(l_debug_info);
707: END IF;
708:
709: DELETE FROM ar_irec_apply_credit_gt
710: WHERE customer_id = p_customer_id
711: AND customer_site_use_id = nvl(p_customer_site_use_id, customer_site_use_id)
712: AND currency_code = p_currency_code
713: AND ( trx_class = 'INV' OR

Line 785: DELETE FROM ar_irec_apply_credit_gt

781: IF (PG_DEBUG = 'Y') THEN
782: arp_standard.debug(l_debug_info);
783: END IF;
784:
785: DELETE FROM ar_irec_apply_credit_gt
786: WHERE customer_id = p_customer_id
787: AND customer_site_use_id = nvl(p_customer_site_use_id, customer_site_use_id)
788: AND currency_code = p_currency_code
789: AND ( trx_class = 'CM' OR

Line 854: DELETE FROM ar_irec_apply_credit_gt

850: IF (PG_DEBUG = 'Y') THEN
851: arp_standard.debug(l_debug_info);
852: END IF;
853:
854: DELETE FROM ar_irec_apply_credit_gt
855: WHERE payment_schedule_id = p_payment_schedule_id;
856:
857: COMMIT;
858:

Line 922: DELETE FROM ar_irec_apply_credit_gt;

918: arp_standard.debug(l_debug_info);
919: END IF;
920: -- Bug 5076215 - Apply Credits GT contains data related to the customer and its related customer,
921: -- the related customer transactions are not getting cleared. Since GT contains only session specific data removed the where condition.
922: DELETE FROM ar_irec_apply_credit_gt;
923: COMMIT;
924:
925: EXCEPTION
926: WHEN OTHERS THEN

Line 998: DELETE FROM ar_irec_apply_credit_gt WHERE PRINTING_OPTION <> 'Y';

994:
995: l_procedure_name := '.apply_credits';
996: x_cash_receipt_id := 0;
997:
998: DELETE FROM ar_irec_apply_credit_gt WHERE PRINTING_OPTION <> 'Y';
999: COMMIT;
1000:
1001: if(p_driving_customer_id is NOT NULL and p_driving_customer_id <> p_customer_id) then
1002: l_customer_id := p_driving_customer_id;

Line 1126: FROM ar_irec_apply_credit_gt

1122: SERVICE_CHARGE,
1123: DISCOUNT_AMOUNT,
1124: APPLICATION_AMOUNT,
1125: CASH_RECEIPT_ID
1126: FROM ar_irec_apply_credit_gt
1127: WHERE CURRENCY_CODE = p_currency_code
1128: AND ( TRX_CLASS = 'INV' OR
1129: TRX_CLASS = 'DM' OR
1130: TRX_CLASS = 'CB' OR

Line 1157: FROM ar_irec_apply_credit_gt

1153: SERVICE_CHARGE,
1154: DISCOUNT_AMOUNT,
1155: APPLICATION_AMOUNT,
1156: CASH_RECEIPT_ID
1157: FROM ar_irec_apply_credit_gt
1158: WHERE CURRENCY_CODE = p_currency_code
1159: AND ( TRX_CLASS = 'CM' OR
1160: TRX_CLASS = 'PMT'
1161: )

Line 1536: FROM ar_irec_apply_credit_gt

1532: SERVICE_CHARGE,
1533: DISCOUNT_AMOUNT,
1534: APPLICATION_AMOUNT,
1535: CASH_RECEIPT_ID
1536: FROM ar_irec_apply_credit_gt
1537: WHERE CURRENCY_CODE = p_currency_code
1538: AND ( TRX_CLASS = 'INV' OR
1539: TRX_CLASS = 'DM' OR
1540: TRX_CLASS = 'CB' OR

Line 1567: FROM ar_irec_apply_credit_gt

1563: SERVICE_CHARGE,
1564: DISCOUNT_AMOUNT,
1565: APPLICATION_AMOUNT,
1566: CASH_RECEIPT_ID
1567: FROM ar_irec_apply_credit_gt
1568: WHERE CURRENCY_CODE = p_currency_code
1569: AND ( TRX_CLASS = 'CM' OR
1570: TRX_CLASS = 'PMT'
1571: )

Line 1976: FROM ar_irec_apply_credit_gt

1972: CUSTOMER_SITE_USE_ID,
1973: TRX_CLASS,
1974: PAYMENT_SCHEDULE_ID,
1975: CURRENCY_CODE
1976: FROM ar_irec_apply_credit_gt
1977: WHERE PAY_FOR_CUSTOMER_ID = p_customer_id
1978: AND ( (PAY_FOR_CUSTOMER_SITE_ID IS NULL AND p_customer_site_use_id IS NULL) OR CUSTOMER_SITE_USE_ID = nvl(p_customer_site_use_id,CUSTOMER_SITE_USE_ID))
1979: AND CURRENCY_CODE = p_currency_code
1980: AND ( TRX_CLASS = 'INV' OR

Line 2079: from ar_irec_apply_credit_gt acgt

2075: x_debit_ps_id OUT NOCOPY NUMBER)
2076: IS
2077: CURSOR credit_to_apply (p_currency_code VARCHAR2) IS
2078: select acgt.payment_schedule_id
2079: from ar_irec_apply_credit_gt acgt
2080: where acgt.currency_code = p_currency_code
2081: and acgt.trx_class = 'PMT'
2082: and (not exists
2083: (

Line 2085: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2081: and acgt.trx_class = 'PMT'
2082: and (not exists
2083: (
2084: select arp.payment_schedule_id
2085: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2086: where acgt1.currency_code = p_currency_code
2087: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2088: and arp.payment_schedule_id = acgt.payment_schedule_id
2089: )

Line 2092: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2088: and arp.payment_schedule_id = acgt.payment_schedule_id
2089: )
2090: or ( (
2091: select sum(amount_applied)
2092: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2093: where acgt1.currency_code = p_currency_code
2094: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2095: and arp.payment_schedule_id = acgt.payment_schedule_id) = 0
2096: )

Line 2104: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1

2100: /*
2101:
2102: CURSOR duplicate_application(p_currency_code VARCHAR2) IS
2103: select acgt.payment_schedule_id, arp.applied_payment_schedule_id
2104: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1
2105: where acgt.currency_code = p_currency_code
2106: and acgt.trx_class = 'PMT'
2107: and acgt.payment_schedule_id = arp.payment_schedule_id
2108: and acgt1.currency_code = p_currency_code

Line 2116: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1

2112: /* bug#6311033-APPLY CREDIT FAILS WITH YOU HAVE PAID SAME INVOICE TWICE ERROR */
2113:
2114: CURSOR duplicate_application(p_currency_code VARCHAR2) IS
2115: select acgt.payment_schedule_id, arp.applied_payment_schedule_id
2116: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1
2117: where acgt.currency_code = p_currency_code
2118: and acgt.trx_class = 'PMT'
2119: and acgt.payment_schedule_id = arp.payment_schedule_id
2120: and acgt1.currency_code = p_currency_code

Line 2124: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2120: and acgt1.currency_code = p_currency_code
2121: and acgt1.payment_schedule_id = arp.applied_payment_schedule_id
2122: and (
2123: select sum(amount_applied)
2124: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2125: where acgt1.currency_code = p_currency_code
2126: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2127: and arp.payment_schedule_id = acgt.payment_schedule_id) > 0;
2128: