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

Line 231: UPDATE ap_invoice_distributions

227: SET bc_event_id = NULL
228: WHERE invoice_id = p_invoice_id
229: AND bc_event_id = rec_event.event_id;
230:
231: UPDATE ap_invoice_distributions
232: SET bc_event_id=NULL
233: WHERE invoice_id = p_invoice_id
234: AND bc_event_id=rec_event.event_id
235: AND nvl(encumbered_flag,'N') <> 'Y';

Line 741: ap_invoice_distributions_all D,

737: NULL, --status_code
738: 'N' self_assessed_flag --self_assessed_flag --bug7109594
739: FROM gl_period_statuses PER,
740: ap_invoices I,
741: ap_invoice_distributions_all D,
742: ap_invoice_lines L
743: WHERE D.invoice_id = I.invoice_id
744: AND D.invoice_line_number = L.line_number
745: AND L.invoice_id = D.invoice_id

Line 786: ap_invoice_distributions_all D,

782: NULL, --status_code
783: 'N' self_assessed_flag --self_assessed_flag --bug7109594
784: FROM gl_period_statuses PER,
785: ap_invoices I,
786: ap_invoice_distributions_all D,
787: ap_invoice_lines L,
788: po_distributions_all pod
789: WHERE D.invoice_id = I.invoice_id
790: AND D.invoice_line_number = L.line_number

Line 823: ap_invoice_distributions_all ainvd,

819: AND D.po_distribution_id = pod.po_distribution_id
820: AND NOT EXISTS ( select 'Advance Exists'
821: from po_distributions_all pod,
822: po_headers_all poh,
823: ap_invoice_distributions_all ainvd,
824: ap_invoices_all ainv,
825: po_doc_style_headers pdsa
826: where pod.po_distribution_id = D.po_distribution_id
827: and poh.po_header_id = pod.po_header_id

Line 921: ap_invoice_distributions_all ainvd,

917: AND T.po_distribution_id is NOT NULL
918: AND NOT EXISTS ( select 'Advance Exists'
919: from po_distributions_all pod,
920: po_headers_all poh,
921: ap_invoice_distributions_all ainvd,
922: ap_invoices_all ainv,
923: po_doc_style_headers pdsa
924: where pod.po_distribution_id = T.po_distribution_id
925: and poh.po_header_id = pod.po_header_id

Line 1067: Update ap_invoice_distributions_all

1063: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||
1064: l_procedure_name, l_log_msg);
1065: END IF;
1066:
1067: Update ap_invoice_distributions_all
1068: set encumbered_flag = 'R'
1069: where invoice_id = p_invoice_id
1070: and line_type_lookup_code = 'REC_TAX';
1071:

Line 1350: FROM ap_invoice_distributions_all aid

1346:
1347: BEGIN
1348: SELECT aid.bc_event_id
1349: INTO l_bc_event_id
1350: FROM ap_invoice_distributions_all aid
1351: WHERE aid.invoice_distribution_id = t_funds_dist_tab(i).inv_distribution_id;
1352:
1353: IF l_bc_event_id IS NOT NULL THEN
1354: SELECT xe.event_status_code

Line 1410: UPDATE ap_invoice_distributions_all aid

1406:
1407: --Bug7153696 modified the below update to catter the self accessed tax invoices
1408: IF nvl(t_funds_dist_tab(i).SELF_ASSESSED_FLAG , 'N') = 'N' THEN
1409:
1410: UPDATE ap_invoice_distributions_all aid
1411: SET aid.encumbered_flag = 'Y'
1412: WHERE aid.invoice_distribution_id = t_funds_dist_tab(i).inv_distribution_id
1413: AND aid.bc_event_id is not null;
1414:

Line 1448: FROM ap_invoice_distributions_all aid

1444: FOR i IN 1..t_funds_dist_tab.COUNT LOOP
1445: BEGIN
1446: SELECT aid.bc_event_id
1447: INTO l_bc_event_id
1448: FROM ap_invoice_distributions_all aid
1449: WHERE aid.invoice_distribution_id = t_funds_dist_tab(i).inv_distribution_id;
1450:
1451: IF l_bc_event_id IS NOT NULL THEN
1452: SELECT xe.event_status_code

Line 1526: UPDATE ap_invoice_distributions_all aid

1522:
1523: --Bug7153696 modified the below update to catter the self accessed tax invoices
1524: IF nvl(t_funds_dist_tab(i).SELF_ASSESSED_FLAG , 'N') = 'N' THEN
1525:
1526: UPDATE ap_invoice_distributions_all aid
1527: SET aid.encumbered_flag = 'Y'
1528: WHERE aid.invoice_distribution_id = t_funds_dist_tab(i).inv_distribution_id
1529: AND aid.bc_event_id is not null;
1530:

Line 1813: FROM ap_invoice_distributions D

1809:
1810: BEGIN
1811: SELECT D.dist_code_combination_id
1812: INTO p_erv_ccid
1813: FROM ap_invoice_distributions D
1814: WHERE D.related_id = p_related_id
1815: AND D.line_type_lookup_code = 'ERV';
1816: EXCEPTION
1817: WHEN NO_DATA_FOUND THEN

Line 2130: from ap_invoice_distributions d,

2126: l_new_qty_var,
2127: l_new_base_qty_var,
2128: l_unapproved_qty,
2129: l_unapproved_amt
2130: from ap_invoice_distributions d,
2131: (SELECT d1.Invoice_distribution_id,
2132: d1.Invoice_ID,
2133: decode(d1.dist_match_type,
2134: 'PRICE_CORRECTION', 0,

Line 2141: FROM ap_invoice_distributions_all d1) qty,

2137: 'ITEM_TO_SERVICE_RECEIPT', 0,
2138: NVL(d1.corrected_quantity, 0) +
2139: NVL(d1.quantity_invoiced,0)
2140: ) quantity_invoiced
2141: FROM ap_invoice_distributions_all d1) qty,
2142: po_distributions pd,
2143: po_line_locations poll
2144: where pd.po_distribution_id = d.po_distribution_id
2145: and d.po_distribution_id = p_po_dist_id

Line 2220: FROM ap_invoice_distributions_all

2216: FROM (SELECT nvl(invoice_line_number,0) line_number,
2217: nvl(distribution_line_number,0) dist_line_number,
2218: row_number() OVER (ORDER BY invoice_line_number,
2219: distribution_line_number) R
2220: FROM ap_invoice_distributions_all
2221: WHERE invoice_id = p_invoice_id
2222: AND po_distribution_id = p_po_dist_id
2223: AND nvl(encumbered_flag,'N') IN ('N','H','P')
2224: AND (match_status_flag IS NULL OR match_status_flag <> 'A')

Line 2231: FROM ap_invoice_distributions_all

2227: 'ITEM_TO_SERVICE_PO',
2228: 'ITEM_TO_SERVICE_RECEIPT')
2229: AND (NVL(corrected_quantity, 0) + NVL(quantity_invoiced,0)) =
2230: (SELECT min(NVL(corrected_quantity, 0) + NVL(quantity_invoiced,0))
2231: FROM ap_invoice_distributions_all
2232: WHERE invoice_id = p_invoice_id
2233: AND po_distribution_id = p_po_dist_id
2234: AND nvl(encumbered_flag,'N') IN ('N','H','P')
2235: AND (match_status_flag IS NULL OR match_status_flag <> 'A')

Line 2266: FROM ap_invoice_distributions_all

2262: FROM (SELECT nvl(invoice_line_number,0) line_number,
2263: nvl(distribution_line_number,0) dist_line_number,
2264: row_number() OVER (ORDER BY invoice_line_number,
2265: distribution_line_number) R
2266: FROM ap_invoice_distributions_all
2267: WHERE invoice_id = p_invoice_id
2268: AND po_distribution_id = p_po_dist_id
2269: AND nvl(encumbered_flag,'N') IN ('N','H','P')
2270: AND (match_status_flag IS NULL OR match_status_flag <> 'A')

Line 2277: FROM ap_invoice_distributions_all

2273: 'ITEM_TO_SERVICE_PO',
2274: 'ITEM_TO_SERVICE_RECEIPT')
2275: AND (NVL(corrected_quantity, 0) + NVL(quantity_invoiced,0)) =
2276: (SELECT max(NVL(corrected_quantity, 0) + NVL(quantity_invoiced,0))
2277: FROM ap_invoice_distributions_all
2278: WHERE invoice_id = p_invoice_id
2279: AND po_distribution_id = p_po_dist_id
2280: AND nvl(encumbered_flag,'N') IN ('N','H','P')
2281: AND (match_status_flag IS NULL OR match_status_flag <> 'A')

Line 2463: from ap_invoice_distributions d,

2459: l_old_base_amt_var,
2460: l_new_amt_var,
2461: l_new_base_amt_var,
2462: l_unapproved_amt
2463: from ap_invoice_distributions d,
2464: po_distributions pd,
2465: po_line_locations poll
2466: where pd.po_distribution_id = d.po_distribution_id
2467: and d.po_distribution_id = p_po_dist_id

Line 2532: from ap_invoice_distributions

2528: select nvl(distribution_line_number,0),
2529: nvl(invoice_line_number,0)
2530: into p_update_dist_num,
2531: p_update_line_num
2532: from ap_invoice_distributions
2533: where (invoice_line_number, distribution_line_number) =
2534: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
2535: from ap_invoice_distributions
2536: where invoice_id = p_invoice_id

Line 2535: from ap_invoice_distributions

2531: p_update_line_num
2532: from ap_invoice_distributions
2533: where (invoice_line_number, distribution_line_number) =
2534: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
2535: from ap_invoice_distributions
2536: where invoice_id = p_invoice_id
2537: and po_distribution_id = p_po_dist_id
2538: and nvl(encumbered_flag,'N') in ('N','H','P')
2539: and (match_status_flag is null or

Line 2543: from ap_invoice_distributions

2539: and (match_status_flag is null or
2540: match_status_flag <> 'A')
2541: and amount =
2542: (select min(amount)
2543: from ap_invoice_distributions
2544: where invoice_id = p_invoice_id
2545: and po_distribution_id = p_po_dist_id
2546: and nvl(encumbered_flag,'N') in ('N','H','P')
2547: and (match_status_flag is null or

Line 2568: from ap_invoice_distributions

2564: select nvl(distribution_line_number,0),
2565: invoice_line_number
2566: into p_update_dist_num,
2567: p_update_line_num
2568: from ap_invoice_distributions
2569: where (invoice_line_number, distribution_line_number) =
2570: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
2571: from ap_invoice_distributions
2572: where invoice_id = p_invoice_id

Line 2571: from ap_invoice_distributions

2567: p_update_line_num
2568: from ap_invoice_distributions
2569: where (invoice_line_number, distribution_line_number) =
2570: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
2571: from ap_invoice_distributions
2572: where invoice_id = p_invoice_id
2573: and po_distribution_id = p_po_dist_id
2574: and nvl(encumbered_flag,'N') in ('N','H','P')
2575: and (match_status_flag is null or

Line 2579: from ap_invoice_distributions

2575: and (match_status_flag is null or
2576: match_status_flag <> 'A')
2577: and amount =
2578: (select max(amount)
2579: from ap_invoice_distributions
2580: where invoice_id = p_invoice_id
2581: and po_distribution_id = p_po_dist_id
2582: and nvl(encumbered_flag,'N') in ('N','H','P')
2583: and (match_status_flag is null or

Line 2674: FROM ap_invoice_distributions_all aid,

2670: AID.org_id, -- org_id
2671: NULL, --result_code
2672: NULL, --status_code
2673: 'N' self_assessed_flag --self_assessed_flag --bug7109594
2674: FROM ap_invoice_distributions_all aid,
2675: ap_invoices_all ai,
2676: ap_invoice_lines_all ail,
2677: gl_period_statuses per
2678: WHERE ai.invoice_id = p_invoice_id

Line 2712: FROM ap_invoice_distributions_all aid,

2708: AID.org_id, -- org_id
2709: NULL, -- result_code
2710: NULL, -- status_code
2711: 'N' self_assessed_flag -- self_assessed_flag --bug7109594
2712: FROM ap_invoice_distributions_all aid,
2713: ap_invoices_all ai,
2714: ap_invoice_lines_all ail,
2715: gl_period_statuses per,
2716: po_distributions_all pod

Line 2744: ap_invoice_distributions_all ainvd,

2740: AND aid.po_distribution_id = pod.po_distribution_id
2741: AND NOT EXISTS ( select 'Advance Exists'
2742: from po_distributions_all pod,
2743: po_headers_all poh,
2744: ap_invoice_distributions_all ainvd,
2745: ap_invoices_all ainv,
2746: po_doc_style_headers pdsa
2747: where pod.po_distribution_id = aid.po_distribution_id
2748: and poh.po_header_id = pod.po_header_id

Line 2828: ap_invoice_distributions_all ainvd,

2824: AND t.po_distribution_id is NOT NULL
2825: AND NOT EXISTS ( select 'Advance Exists'
2826: from po_distributions_all pod,
2827: po_headers_all poh,
2828: ap_invoice_distributions_all ainvd,
2829: ap_invoices_all ainv,
2830: po_doc_style_headers pdsa
2831: where pod.po_distribution_id = t.po_distribution_id
2832: and poh.po_header_id = pod.po_header_id

Line 2937: Update ap_invoice_distributions_all

2933: 'tax distributions to R';
2934: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||
2935: l_procedure_name, l_log_msg);
2936: END IF;
2937: Update ap_invoice_distributions_all
2938: set encumbered_flag = 'R'
2939: where invoice_id = p_invoice_id
2940: and line_type_lookup_code = 'REC_TAX';
2941: