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.OZF_AR_PAYMENT_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 521: --p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

517: p_receipt_number => NULL, --p_claim_rec.receipt_number,
518: p_amount_applied => l_amount_applied,
519: --p_apply_date => SYSDATE, --AR should default
520: --p_apply_gl_date => p_claim_rec.gl_date, --11.5.10 Enhancements. AR should default
521: --p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
522: --p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
523: -- Global Flexfield parameters
524: --p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
525: p_comments => SUBSTRB(p_claim_rec.comments, 1, 240),

Line 766: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

762: p_amount_applied_from => p_new_applied_from_amount,--4684931
763: p_apply_date => p_apply_date, -- Fix for Bug 3091401. TM passes old apply date
764: -- this is the allocated receipt amount
765: /*
766: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
767: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
768: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 767: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

763: p_apply_date => p_apply_date, -- Fix for Bug 3091401. TM passes old apply date
764: -- this is the allocated receipt amount
765: /*
766: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
767: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
768: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
771: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 768: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,

764: -- this is the allocated receipt amount
765: /*
766: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
767: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
768: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
771: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
772: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,

Line 769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

765: /*
766: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
767: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
768: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
771: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
772: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
773: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

Line 770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

766: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
767: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
768: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
771: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
772: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
773: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
774: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',

Line 771: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

767: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
768: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
771: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
772: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
773: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
774: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
775: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 772: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,

768: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
771: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
772: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
773: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
774: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
775: p_called_from IN VARCHAR2 DEFAULT NULL,
776: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

Line 777: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

773: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
774: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
775: p_called_from IN VARCHAR2 DEFAULT NULL,
776: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
777: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
778: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
779: */
780: -- ******* Global Flexfield parameters *******
781: --p_global_attribute_rec => p_global_attribute_rec,

Line 1585: FROM ar_receivable_applications

1581: , cv_claim_id IN NUMBER
1582: ) IS
1583: SELECT receivable_application_id
1584: , applied_payment_schedule_id
1585: FROM ar_receivable_applications
1586: WHERE cash_receipt_id = cv_cash_receipt_id
1587: AND applied_customer_trx_id = cv_customer_trx_id
1588: AND application_ref_type = 'CLAIM'
1589: ANd secondary_application_ref_id = cv_claim_id

Line 1638: FROM ar_receivable_applications rec

1634: SELECT pay.amount_due_remaining,
1635: pay.amount_line_items_remaining,
1636: pay.tax_remaining,
1637: pay.freight_remaining
1638: FROM ar_receivable_applications rec
1639: , ar_payment_schedules pay
1640: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
1641: AND rec.cash_receipt_id = cv_cash_receipt_id
1642: AND pay.customer_trx_id = cv_customer_trx_id

Line 2239: FROM ar_receivable_applications rec

2235: , rec.application_ref_num
2236: , rec.secondary_application_ref_id
2237: , rec.application_ref_reason
2238: , rec.customer_reference
2239: FROM ar_receivable_applications rec
2240: , ar_payment_schedules pay
2241: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2242: AND rec.cash_receipt_id = cv_cash_receipt_id
2243: AND pay.customer_trx_id = cv_customer_trx_id

Line 2255: FROM ar_receivable_applications_all rec

2251: WHERE claim_id = cv_claim_id;
2252:
2253: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2254: SELECT rec.cash_receipt_id
2255: FROM ar_receivable_applications_all rec
2256: , ar_payment_schedules pay
2257: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2258: AND pay.customer_trx_id = cv_invoice_id;
2259:

Line 2263: FROM ar_receivable_applications rec

2259:
2260: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER
2261: , cv_root_claim_id IN NUMBER) IS
2262: SELECT rec.amount_applied
2263: FROM ar_receivable_applications rec
2264: WHERE rec.applied_payment_schedule_id = -4
2265: AND rec.cash_receipt_id = cv_cash_receipt_id
2266: AND rec.application_ref_type = 'CLAIM'
2267: AND rec.display = 'Y'

Line 2867: FROM ar_receivable_applications rec

2863: , rec.application_ref_num
2864: , rec.secondary_application_ref_id
2865: , rec.application_ref_reason
2866: , rec.customer_reference
2867: FROM ar_receivable_applications rec
2868: , ar_payment_schedules pay
2869: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2870: AND rec.cash_receipt_id = cv_cash_receipt_id
2871: AND pay.customer_trx_id = cv_customer_trx_id

Line 2891: FROM ar_receivable_applications_all rec

2887:
2888:
2889: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2890: SELECT rec.cash_receipt_id
2891: FROM ar_receivable_applications_all rec
2892: , ar_payment_schedules pay
2893: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2894: AND pay.customer_trx_id = cv_invoice_id;
2895:

Line 2899: FROM ar_receivable_applications rec

2895:
2896: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER
2897: , cv_root_claim_id IN NUMBER) IS
2898: SELECT rec.amount_applied
2899: FROM ar_receivable_applications rec
2900: WHERE rec.applied_payment_schedule_id = -4
2901: AND rec.cash_receipt_id = cv_cash_receipt_id
2902: AND rec.application_ref_type = 'CLAIM'
2903: AND rec.display = 'Y'

Line 3096: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date

3092: l_p_new_applied_from_amount NUMBER;
3093: l_receipt_currency VARCHAR2(15);
3094: l_trx_currency VARCHAR2(15);
3095: l_cm_applied_on_rec_amt NUMBER;
3096: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date
3097: l_cm_applied_on_rec_amt_from NUMBER;
3098:
3099: -- Fix for Bug 7494234
3100: CURSOR csr_old_applied_invoice( cv_cash_receipt_id IN NUMBER

Line 3109: FROM ar_receivable_applications rec

3105: , rec.application_ref_num
3106: , rec.secondary_application_ref_id
3107: , sum(rec.amount_applied) amount_applied
3108: , sum(rec.amount_applied_from) amount_applied_from --4684931
3109: FROM ar_receivable_applications rec
3110: , ar_payment_schedules pay
3111: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3112: AND rec.cash_receipt_id = cv_cash_receipt_id
3113: AND pay.customer_trx_id = cv_customer_trx_id

Line 3130: FROM ar_receivable_applications rec

3126: , rec.customer_reference
3127: , rec.amount_applied
3128: , rec.amount_applied_from --4684931
3129: , pay.amount_due_remaining
3130: FROM ar_receivable_applications rec
3131: , ar_payment_schedules pay
3132: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3133: AND rec.cash_receipt_id = cv_cash_receipt_id
3134: AND pay.customer_trx_id = cv_customer_trx_id

Line 3144: FROM ar_receivable_applications

3140: l_old_applied_invoice csr_old_applied_invoice%ROWTYPE;
3141:
3142: CURSOR csr_claim_investigation_amount(cv_root_claim_id IN NUMBER) IS
3143: SELECT amount_applied
3144: FROM ar_receivable_applications
3145: WHERE application_ref_type = 'CLAIM'
3146: AND applied_payment_schedule_id = -4
3147: AND display = 'Y'
3148: AND secondary_application_ref_id = cv_root_claim_id;

Line 3154: FROM ar_receivable_applications

3150: CURSOR csr_cm_exist_on_rec(cv_cash_receipt_id IN NUMBER, cv_customer_trx_id IN NUMBER) IS
3151: SELECT amount_applied,
3152: amount_applied_from, --4684931
3153: apply_date -- Fix for Bug 3091401. TM passes old apply date
3154: FROM ar_receivable_applications
3155: WHERE cash_receipt_id = cv_cash_receipt_id
3156: AND applied_customer_trx_id = cv_customer_trx_id
3157: AND display = 'Y'
3158: AND status = 'APP';

Line 3554: FROM ar_receivable_applications rec

3550:
3551: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER
3552: , cv_root_claim_id IN NUMBER) IS
3553: SELECT rec.amount_applied
3554: FROM ar_receivable_applications rec
3555: WHERE rec.applied_payment_schedule_id = -4
3556: AND rec.cash_receipt_id = cv_cash_receipt_id
3557: AND rec.application_ref_type = 'CLAIM'
3558: AND rec.display = 'Y'

Line 3947: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date

3943: l_p_new_applied_from_amount NUMBER; --bug 4684931
3944: l_receipt_currency VARCHAR2(15);
3945: l_trx_currency VARCHAR2(15);
3946: l_dm_applied_on_rec_amt NUMBER ;
3947: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date
3948: l_dm_applied_on_rec_amt_from NUMBER;
3949:
3950: CURSOR csr_dm_trx_type_id(cv_claim_type_id IN NUMBER) IS
3951: SELECT dm_trx_type_id

Line 3957: FROM ar_receivable_applications

3953: WHERE claim_type_id = cv_claim_type_id;
3954:
3955: CURSOR csr_claim_investigation_amount(cv_root_claim_id IN NUMBER) IS
3956: SELECT amount_applied
3957: FROM ar_receivable_applications
3958: WHERE application_ref_type = 'CLAIM'
3959: AND applied_payment_schedule_id = -4
3960: AND display = 'Y'
3961: AND secondary_application_ref_id = cv_root_claim_id;

Line 3972: FROM ar_receivable_applications

3968: CURSOR csr_dm_exist_on_rec(cv_cash_receipt_id IN NUMBER, cv_customer_trx_id IN NUMBER) IS
3969: SELECT amount_applied,
3970: amount_applied_from,--bug 4684931
3971: apply_date -- Fix for Bug 3091401. TM passes old apply date
3972: FROM ar_receivable_applications
3973: WHERE cash_receipt_id = cv_cash_receipt_id
3974: AND applied_customer_trx_id = cv_customer_trx_id
3975: AND display = 'Y'
3976: AND status = 'APP';