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.JAI_AP_UTILS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 21: instead of ap_invoice_distributions_all

17: 23-Jun-2005 Brathod , File Version 112.0 , Bug# 4445989
18: - Signature for procedure get_aportion_factor is modified to use invoice_id and
19: invoice_line_number
20: - Code modified to fetch the details from ap_invoice_lines_all
21: instead of ap_invoice_distributions_all
22:
23: 02-Sep-2005 Ramananda for Bug#4584221, File Version 120.2
24: Added the new function get_tds_invoice_batch
25: In the form regime registrations (JAIREGIM.fmb) attribute_value field is a free flowing text.

Line 1325: v_invoice_quantity ap_invoice_distributions_all.quantity_invoiced%type;

1321: WHERE invoice_id = inv_id;
1322: -- iSupplier porting
1323:
1324:
1325: v_invoice_quantity ap_invoice_distributions_all.quantity_invoiced%type;
1326: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1327: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1328: v_source ap_invoices_all.source%type; --iSuppleir porting
1329:

Line 1326: v_invoice_price ap_invoice_distributions_all.unit_price%type;

1322: -- iSupplier porting
1323:
1324:
1325: v_invoice_quantity ap_invoice_distributions_all.quantity_invoiced%type;
1326: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1327: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1328: v_source ap_invoices_all.source%type; --iSuppleir porting
1329:
1330: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;

Line 1327: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting

1323:
1324:
1325: v_invoice_quantity ap_invoice_distributions_all.quantity_invoiced%type;
1326: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1327: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1328: v_source ap_invoices_all.source%type; --iSuppleir porting
1329:
1330: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1331: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/

Line 1339: v_po_distribution_id ap_invoice_distributions_all.po_distribution_id%type;

1335:
1336: v_po_price po_line_locations_all.price_override%type;
1337: v_po_quantity po_line_locations_all.quantity%type;
1338:
1339: v_po_distribution_id ap_invoice_distributions_all.po_distribution_id%type;
1340: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
1341:
1342: v_uom_conv_factor number;
1343:

Line 1340: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;

1336: v_po_price po_line_locations_all.price_override%type;
1337: v_po_quantity po_line_locations_all.quantity%type;
1338:
1339: v_po_distribution_id ap_invoice_distributions_all.po_distribution_id%type;
1340: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
1341:
1342: v_uom_conv_factor number;
1343:
1344:

Line 2201: from ap_invoice_distributions_all

2197:
2198: Cursor get_misc_lines (ln_dist_line_number in number,
2199: ln_invoice_id in number ) is
2200: select *
2201: from ap_invoice_distributions_all
2202: where invoice_id = ln_invoice_id
2203: and distribution_line_number = ln_dist_line_number;
2204:
2205:

Line 2329: update ap_invoice_distributions_all

2325: fnd_file.put_line(FND_FILE.LOG,' Inside IPV not zero '|| ln_tax_ipv);
2326:
2327: ln_tax_bipv := ln_tax_ipv * nvl(r_get_misc_lines.exchange_rate,1);
2328:
2329: update ap_invoice_distributions_all
2330: set invoice_price_variance = round(ln_tax_ipv,ln_inv_pre),
2331: base_invoice_price_variance = round(ln_tax_bipv, ln_base_pre),
2332: price_var_code_combination_id = P_price_var_ccid
2333: where invoice_distribution_id = r_get_misc_lines.invoice_distribution_id;

Line 2344: update ap_invoice_distributions_all

2340:
2341: fnd_file.put_line(FND_FILE.LOG,' Inside ERV not zero '|| ln_tax_erv);
2342: fnd_file.put_line(FND_FILE.LOG,' rate var CCID '|| P_rate_var_ccid);
2343:
2344: update ap_invoice_distributions_all
2345: set exchange_rate_variance = round(ln_tax_erv,ln_inv_pre),
2346: rate_var_code_combination_id = P_rate_var_ccid
2347: where invoice_distribution_id = r_get_misc_lines.invoice_distribution_id;
2348: End if;

Line 2355: update ap_invoice_distributions_all

2351: Else
2352:
2353: /* update ipv and bipv to 0. no need to update Var CCID */
2354:
2355: update ap_invoice_distributions_all
2356: set invoice_price_variance = 0,
2357: base_invoice_price_variance = 0,
2358: exchange_rate_variance = 0
2359: where invoice_distribution_id = r_get_misc_lines.invoice_distribution_id;

Line 2425: from ap_invoice_distributions_all

2421:
2422: cursor c_base_inv_amt
2423: is
2424: select amount
2425: from ap_invoice_distributions_all
2426: where invoice_distribution_id = p_parent_dist_id
2427: and invoice_id = p_invoice_id ;
2428:
2429: ln_line_amt number ;

Line 2769: ln_invoice_line_num ap_invoice_distributions_all.invoice_line_number%TYPE;

2765: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;
2766: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;
2767: ln_item_line_amt ap_invoice_lines_all.amount%TYPE;
2768:
2769: ln_invoice_line_num ap_invoice_distributions_all.invoice_line_number%TYPE;
2770: lv_inclu_tax_flag jai_ap_tds_years.inclusive_tax_flag%TYPE;
2771: ln_inv_org_id mtl_parameters.organization_id%TYPE;
2772: lv_inv_org_code mtl_parameters.organization_code%TYPE;
2773:

Line 2832: ap_invoice_distributions_all

2828: SELECT
2829: dist_code_combination_id
2830: , amount
2831: FROM
2832: ap_invoice_distributions_all
2833: WHERE invoice_id = pn_invoice_id
2834: AND invoice_line_number = pn_invoice_line_num;
2835:
2836: BEGIN

Line 2901: ap_invoice_distributions_all aida

2897: aila.line_number
2898: INTO
2899: ln_invoice_line_num
2900: FROM
2901: ap_invoice_distributions_all aida
2902: , ap_invoice_lines_all aila
2903: WHERE aida.invoice_distribution_id = pn_invoice_distribution_id
2904: AND aila.line_number = aida.invoice_line_number
2905: AND aila.invoice_id = pn_invoice_id

Line 2960: ap_invoice_distributions_all aida

2956: COUNT(invoice_distribution_id)
2957: INTO
2958: ln_invoice_post_num
2959: FROM
2960: ap_invoice_distributions_all aida
2961: WHERE aida.invoice_id = pn_invoice_id
2962: AND aida.invoice_line_number = ln_invoice_line_num
2963: AND aida.posted_flag = 'Y';
2964: