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.AP_PREPAY_UTILS_PKG dependencies on AP_INVOICE_LINES

Line 91: UPDATE ap_invoice_lines

87:
88: -- This would lock the selected lines for both the
89: -- online and the batch cases.
90:
91: UPDATE ap_invoice_lines
92: SET line_selected_for_appl_flag = 'Y',
93: prepay_appl_request_id = p_request_id
94: WHERE invoice_id = p_invoice_id
95: AND line_number = p_line_number;

Line 113: UPDATE ap_invoice_lines

109: P_line_number IN NUMBER) RETURN BOOLEAN
110: IS
111: PRAGMA AUTONOMOUS_TRANSACTION;
112: BEGIN
113: UPDATE ap_invoice_lines
114: SET line_selected_for_appl_flag = 'N',
115: prepay_appl_request_id = NULL
116: WHERE invoice_id = p_invoice_id
117: AND line_number = p_line_number;

Line 138: UPDATE ap_invoice_lines

134:
135: -- This would lock the selected lines for both the
136: -- online and the batch cases.
137:
138: UPDATE ap_invoice_lines
139: SET line_selected_for_appl_flag = 'N',
140: prepay_appl_request_id = NULL
141: WHERE ( prepay_appl_request_id = p_request_id
142: OR prepay_appl_request_id IS NULL)

Line 167: FROM ap_invoice_lines

163: SELECT NVL(line_selected_for_appl_flag,'N'),
164: prepay_appl_request_id
165: INTO l_already_selected_flag,
166: l_request_id
167: FROM ap_invoice_lines
168: WHERE invoice_id = p_invoice_id
169: AND line_number = p_line_number;
170:
171: IF l_already_selected_flag = 'Y' AND

Line 267: FROM ap_invoice_lines_all

263: --bug4944102. As part of Performance fic for invoice workbench
264: --fixed the following query
265: /* SELECT (0 - SUM(NVL(amount,0)))
266: INTO l_prepaid_amount
267: FROM ap_invoice_lines_all
268: WHERE invoice_id = l_invoice_id
269: AND line_type_lookup_code IN ('PREPAY', 'TAX')
270: AND NVL(invoice_includes_prepay_flag, 'N') = 'N' -- Bug 5675960. Added the NVL
271: AND nvl(prepay_invoice_id,-999)<>-999

Line 277: ap_invoice_lines_all ail

273:
274: SELECT (0 - SUM(NVL(aid.amount,0)))
275: INTO l_prepaid_amount
276: FROM ap_invoice_distributions_all aid,
277: ap_invoice_lines_all ail
278: WHERE ail.invoice_id = l_invoice_id
279: AND ail.invoice_id = aid.invoice_id
280: AND ail.line_number = aid.invoice_line_number
281: AND aid.line_type_lookup_code = 'PREPAY'

Line 420: ap_invoice_lines_all ail

416: CURSOR prepay_cursor is
417: SELECT SUM(total_dist_amount -
418: NVL(prepay_amount_remaining, total_dist_amount))
419: FROM ap_invoice_distributions_all aid,
420: ap_invoice_lines_all ail
421: WHERE aid.invoice_id = P_invoice_id
422: AND aid.invoice_id = ail.invoice_id
423: AND aid.invoice_line_number = ail.line_number
424: AND ail.line_type_lookup_code <> 'TAX'

Line 434: FROM ap_invoice_lines_all ail

430: AND NVL(reversal_flag,'N') <> 'Y';
431:
432: CURSOR inv_prepay_cursor is
433: SELECT ABS(SUM(amount))
434: FROM ap_invoice_lines_all ail
435: WHERE ail.invoice_id = P_invoice_id
436: AND ail.line_type_lookup_code = 'PREPAY';
437:
438: BEGIN

Line 474: ap_invoice_lines_all ail

470: -- exclusive tax will not.
471: CURSOR c_prepay_amount_remaining IS
472: SELECT SUM(nvl(prepay_amount_remaining, total_dist_amount))
473: FROM ap_invoice_distributions_all aid,
474: ap_invoice_lines_all ail
475: WHERE aid.invoice_id = P_invoice_id
476: AND aid.invoice_id = ail.invoice_id
477: AND aid.invoice_line_number = ail.line_number
478: AND ail.line_type_lookup_code <> 'TAX'

Line 569: ap_invoice_lines_all ail

565: SELECT SUM((NVL(aid1.amount, 0) - NVL(aid1.prepay_tax_diff_amount, 0))* -1)
566: INTO l_prepay_amt_applied
567: FROM ap_invoice_distributions_all aid1,
568: ap_invoice_distributions_all aid2,
569: ap_invoice_lines_all ail
570: WHERE aid1.invoice_id = P_invoice_id
571: AND aid1.line_type_lookup_code IN ('PREPAY', 'REC_TAX', 'NONREC_TAX')
572: AND aid1.invoice_id = ail.invoice_id
573: AND aid1.invoice_line_number = ail.line_number

Line 602: FROM ap_invoice_lines_all ail

598: -- Tax: inclusive included, exclusive is not.
599:
600: SELECT SUM(ail.amount * -1)
601: INTO l_prepay_amt_applied
602: FROM ap_invoice_lines_all ail
603: WHERE ail.invoice_id = P_invoice_id
604: AND ail.line_type_lookup_code = 'PREPAY'
605: AND ail.prepay_invoice_id = P_prepay_id;
606:

Line 743: FROM ap_invoice_lines_all ail

739:
740: BEGIN
741: SELECT SUM(NVL(ail.amount, 0))
742: INTO l_exclusive_tax_amt_applied
743: FROM ap_invoice_lines_all ail
744: WHERE ail.invoice_id = X_invoice_id
745: AND ail.line_type_lookup_code = 'TAX'
746: AND NVL(ail.discarded_flag, 'N') <> 'Y'
747: AND NVL(ail.cancelled_flag, 'N') <> 'Y'

Line 788: FROM ap_invoice_lines_all ail

784:
785: /* Commented for bug 7506584
786: CURSOR c_invoice_lines_info IS
787: SELECT NVL(SUM(NVL(ail.amount,0)), 0)
788: FROM ap_invoice_lines_all ail
789: WHERE ail.invoice_id = X_Invoice_Id
790: AND ail.line_type_lookup_code <> 'TAX'
791: AND (ail.line_type_lookup_code <> 'PREPAY'
792: OR NVL(ail.invoice_includes_prepay_flag,'N') = 'Y'); */

Line 840: FROM ap_invoice_lines_all ail

836: INTO l_tax_lines,
837: l_non_tax_lines,
838: --l_prep_applied, /*Commented for bug 12742360*/
839: l_awt_lines
840: FROM ap_invoice_lines_all ail
841: WHERE ail.invoice_id = x_invoice_id;
842:
843: --bug 12742360 :Modified SQL to find the prepay applied amount that includes the prepay tax
844: -- commented code above that computes l_prep_applied

Line 849: ap_invoice_lines_all ail

845:
846: Select nvl(SUM(aid.amount),0)
847: into l_prep_applied
848: from ap_invoice_distributions_all aid,
849: ap_invoice_lines_all ail
850: Where ail.invoice_id = aid.invoice_id
851: and ail.line_number = aid.invoice_line_number
852: and nvl(ail.invoice_includes_prepay_flag,'N') = 'N'
853: and aid.prepay_distribution_id is not null

Line 862: FROM ap_invoice_lines_all ail

858: --item amount without any tax, AWT or prepay
859:
860: SELECT nvl(SUM(nvl(amount, 0)), 0)
861: INTO l_item_lines_proration
862: FROM ap_invoice_lines_all ail
863: WHERE ail.invoice_id = x_invoice_id
864: AND ail.line_type_lookup_code not in ('TAX','AWT') /*9338463: AWT should not be considered*/
865: AND(ail.line_type_lookup_code <> 'PREPAY' OR nvl(ail.invoice_includes_prepay_flag, 'N') = 'Y');
866:

Line 870: FROM ap_invoice_lines_all ail

866:
867: --tax amount that is part of the invoice and not any prepayment
868: SELECT nvl(SUM(nvl(amount, 0)), 0)
869: INTO l_tax_lines_proration
870: FROM ap_invoice_lines_all ail
871: WHERE ail.invoice_id = x_invoice_id
872: AND ail.line_type_lookup_code = 'TAX'
873: AND (ail.amount > 0 OR nvl(ail.invoice_includes_prepay_flag, 'N') = 'Y'); /*Bug 9338463: invoice includes prepay check added*/
874:

Line 1061: FROM ap_invoice_lines_all ail

1057:
1058: /* Commented for bug 7506584
1059: CURSOR c_invoice_lines_info IS
1060: SELECT NVL(SUM(NVL(ail.amount,0)), 0)
1061: FROM ap_invoice_lines_all ail
1062: WHERE ail.invoice_id = X_Invoice_Id
1063: AND (ail.line_type_lookup_code <> 'PREPAY'
1064: OR NVL(ail.invoice_includes_prepay_flag,'N') = 'Y');
1065:

Line 1183: FROM ap_invoice_lines_all ail

1179: WHERE ai.invoice_id = X_Invoice_Id;
1180:
1181: CURSOR c_invoice_lines_info IS
1182: SELECT NVL(SUM(NVL(ail.included_tax_amount,0)), 0)
1183: FROM ap_invoice_lines_all ail
1184: WHERE ail.invoice_id = X_Invoice_Id
1185: AND (ail.line_type_lookup_code <> 'PREPAY'
1186: OR NVL(ail.invoice_includes_prepay_flag,'N') = 'Y');
1187:

Line 1295: l_inv_incl_pp_flag ap_invoice_lines_all.invoice_includes_prepay_flag%type;

1291: X_Invoice_Id IN NUMBER,
1292: X_prepay_invoice_id IN NUMBER,
1293: X_prepay_Line_Number IN NUMBER DEFAULT NULL) RETURN VARCHAR2
1294: IS
1295: l_inv_incl_pp_flag ap_invoice_lines_all.invoice_includes_prepay_flag%type;
1296:
1297: BEGIN
1298:
1299: Select case

Line 1302: From ap_invoice_lines_all ail

1298:
1299: Select case
1300: when exists
1301: (select 1
1302: From ap_invoice_lines_all ail
1303: where ail.invoice_id = X_Invoice_Id
1304: and ail.line_type_lookup_code = 'PREPAY'
1305: and ail.prepay_invoice_id = X_prepay_invoice_id
1306: and ail.prepay_line_number = nvl(X_prepay_Line_Number,ail.prepay_line_number)

Line 1317: From ap_invoice_lines_all ail

1313: and aid.prepay_amount_remaining > 0)) Then
1314: 'Y'
1315: when exists
1316: (select 1
1317: From ap_invoice_lines_all ail
1318: where ail.invoice_id = X_Invoice_Id
1319: and ail.line_type_lookup_code = 'PREPAY'
1320: and ail.prepay_invoice_id = X_prepay_invoice_id
1321: and ail.prepay_line_number = nvl(X_prepay_Line_Number,ail.prepay_line_number)