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_CANCEL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 65: FROM ap_invoice_distributions AID,

61:
62: -- Bug5497058
63: CURSOR qty_per_dist_negtive_count_cur IS
64: SELECT count(*)
65: FROM ap_invoice_distributions AID,
66: po_distributions_ap_v POD,
67: po_line_locations PLL,
68: po_lines PL,
69: ap_invoices AIV

Line 102: FROM ap_invoice_distributions AID

98:
99:
100: CURSOR dist_gl_date_cur IS
101: SELECT accounting_date
102: FROM ap_invoice_distributions AID
103: WHERE AID.invoice_id = P_invoice_id
104: AND NVL(AID.reversal_flag, 'N') <> 'Y';
105:
106: TYPE date_tab is TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 318: FROM ap_invoice_distributions AID,

314: BEGIN
315:
316: SELECT 'N'
317: INTO l_allow_cancel
318: FROM ap_invoice_distributions AID,
319: po_distributions PD,
320: po_line_locations pll
321: WHERE aid.invoice_id = p_invoice_id
322: --AND aid.final_match_flag in ('N','Y') For Bug 3489536

Line 340: FROM ap_invoice_distributions aid,

336: WHEN NO_DATA_FOUND THEN
337:
338: SELECT count(distinct pll.line_location_id)
339: INTO l_final_closed_shipment_count
340: FROM ap_invoice_distributions aid,
341: po_line_locations pll,
342: po_distributions pd
343: WHERE aid.invoice_id = p_invoice_id
344: AND aid.po_distribution_id = pd.po_distribution_id

Line 406: from ap_invoice_distributions AIL

402: FROM ap_invoices AI
403: WHERE AI.invoice_id = P_invoice_id
404: AND (AI.project_id is not null OR
405: exists (select 'X'
406: from ap_invoice_distributions AIL
407: where AIL.invoice_id = AI.invoice_id
408: and project_id is not null) OR
409: exists (select 'X'
410: from ap_invoice_distributions AID

Line 410: from ap_invoice_distributions AID

406: from ap_invoice_distributions AIL
407: where AIL.invoice_id = AI.invoice_id
408: and project_id is not null) OR
409: exists (select 'X'
410: from ap_invoice_distributions AID
411: where AID.invoice_id = AI.invoice_id
412: and project_id is not null));
413:
414: IF (l_project_related_count <> 0) THEN

Line 466: ap_invoice_distributions AID,

462: select 'Y'
463: into l_po_not_approved
464: from po_headers POH,
465: po_distributions POD,
466: ap_invoice_distributions AID,
467: ap_invoices AI
468: where AI.invoice_id = AID.invoice_id
469: and AI.invoice_id = P_invoice_id
470: and AID.po_distribution_id = POD.po_distribution_id

Line 608: FROM ap_invoice_distributions_all aid

604: AND APR.Registration_Event_Type = 'INVOICE_CANCELLED';
605:
606: cursor dist_debug_cur is
607: Select *
608: FROM ap_invoice_distributions_all aid
609: WHERE aid.invoice_id = p_invoice_id;
610:
611: l_inv_line_rec_list Inv_Line_Tab_Type;
612: l_ok_to_cancel BOOLEAN := FALSE;

Line 642: l_Accounting_event_ID AP_INVOICE_DISTRIBUTIONS_ALL.accounting_event_id%TYPE;

638: l_self_assess_tax_count NUMBER := 0 ; -- Bug 6694536
639: l_tax_dist_count NUMBER := 0; -- Bug 6815172
640:
641: -- Bug 4748638
642: l_Accounting_event_ID AP_INVOICE_DISTRIBUTIONS_ALL.accounting_event_id%TYPE;
643: l_cancel_dist_exists NUMBER := 0;
644: l_open_gl_date AP_INVOICES_ALL.gl_date%type;
645: l_funds_return_code VARCHAR2(30); -- 4276409 (3462325)
646:

Line 696: FROM ap_invoice_distributions AID

692:
693: -- Bug 9497953 : Start
694: SELECT TRUNC( NVL( MAX( AID.accounting_date ) , P_accounting_date ) )
695: INTO l_max_inv_dist_acc_date
696: FROM ap_invoice_distributions AID
697: WHERE AID.invoice_id = P_invoice_id
698: AND AID.awt_invoice_payment_id IS NULL ;
699:
700: SELECT TRUNC( NVL( MAX( AIP.accounting_date ) , P_accounting_date ) )

Line 746: FROM ap_invoice_distributions

742: l_debug_info := 'Check if AWT has been performed by AutoApproval';
743:
744: SELECT count(*)
745: INTO l_count
746: FROM ap_invoice_distributions
747: WHERE invoice_id = P_invoice_id
748: AND NVL(awt_flag,'N') = 'A' --bug 9702328
749: AND NVL(reversal_flag,'N') <> 'Y';
750:

Line 806: UPDATE ap_invoice_distributions aid

802: AP_FUNDS_CONTROL_PKG.Encum_Unprocessed_Events_Del
803: (p_invoice_id => p_invoice_id,
804: p_calling_sequence => l_curr_calling_sequence);
805:
806: UPDATE ap_invoice_distributions aid
807: SET aid.encumbered_flag = 'R'
808: WHERE aid.invoice_id = p_invoice_id
809: AND nvl(aid.match_status_flag,'N') <> 'A'
810: AND nvl(aid.encumbered_flag,'N') <> 'Y'

Line 955: ap_invoice_distributions ap_dist

951:
952: SELECT count(*)
953: INTO l_tax_dist_count
954: FROM zx_rec_nrec_dist zx_dist,
955: ap_invoice_distributions ap_dist
956: WHERE ap_dist.invoice_id = p_invoice_id
957: AND ap_dist.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
958: AND nvl(zx_dist.reverse_flag, 'N') <> 'Y'
959: AND nvl(zx_dist.inclusive_flag, 'N') = 'Y'

Line 1030: from ap_invoice_distributions aid1

1026:
1027: IF nvl(l_cancel_proactive_flag,'N') ='C' then
1028:
1029: For I in(select invoice_distribution_id
1030: from ap_invoice_distributions aid1
1031: where aid1.invoice_id=P_invoice_id
1032: and aid1.parent_reversal_id is null --original dist
1033: --for original dists there is no reversal dist created
1034: and ( not exists (select 1 from ap_invoice_distributions aid2

Line 1034: and ( not exists (select 1 from ap_invoice_distributions aid2

1030: from ap_invoice_distributions aid1
1031: where aid1.invoice_id=P_invoice_id
1032: and aid1.parent_reversal_id is null --original dist
1033: --for original dists there is no reversal dist created
1034: and ( not exists (select 1 from ap_invoice_distributions aid2
1035: where aid1.invoice_id=aid2.invoice_id
1036: and aid2.invoice_id=P_invoice_id
1037: and aid2.invoice_line_number=aid1.invoice_line_number
1038: and aid2.parent_reversal_id =aid1.invoice_distribution_id)

Line 1040: or exists (select 1 from ap_invoice_distributions aid2

1036: and aid2.invoice_id=P_invoice_id
1037: and aid2.invoice_line_number=aid1.invoice_line_number
1038: and aid2.parent_reversal_id =aid1.invoice_distribution_id)
1039: --the reversal dist does not reverse the amount correctly
1040: or exists (select 1 from ap_invoice_distributions aid2
1041: where aid1.invoice_id=aid2.invoice_id
1042: and aid2.invoice_id=P_invoice_id
1043: and aid2.invoice_line_number=aid1.invoice_line_number
1044: and aid2.parent_reversal_id =aid1.invoice_distribution_id

Line 1239: FROM ap_invoice_distributions

1235: -- Start Bug fix 4748638 (4881719)
1236: --Bug#3574680, determine if cancelled distributions exists
1237: SELECT COUNT(invoice_distribution_id)
1238: INTO l_cancel_dist_exists
1239: FROM ap_invoice_distributions
1240: WHERE invoice_id=p_invoice_id
1241: AND cancellation_flag='Y'
1242: AND rownum=1;
1243:

Line 1272: FROM ap_invoice_distributions AID,

1268:
1269: -- Bug 9362054 : Begin
1270: SELECT COUNT(1)
1271: INTO l_unsuccessful_cancel
1272: FROM ap_invoice_distributions AID,
1273: financials_system_params_all FSP
1274: WHERE AID.invoice_id = P_invoice_id
1275: AND FSP.org_id = AID.org_id
1276: AND FSP.set_of_books_id = AID.set_of_books_id