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_LINES_ALL

Line 20: - Code modified to fetch the details from ap_invoice_lines_all

16:
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

Line 1264: pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE

1260:
1261: /* Brathod, For Bug# 4445989, get_apportion_factor signature is modified to use invoice_id and line_number*/
1262: FUNCTION get_apportion_factor(
1263: -- p_invoice_distribution_id in number
1264: pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE
1265: , pn_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE,
1266: --added the following parameter by vkaranam for bug #5989740
1267: p_factor_type varchar2 default null
1268: ) return number

Line 1265: , pn_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE,

1261: /* Brathod, For Bug# 4445989, get_apportion_factor signature is modified to use invoice_id and line_number*/
1262: FUNCTION get_apportion_factor(
1263: -- p_invoice_distribution_id in number
1264: pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE
1265: , pn_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE,
1266: --added the following parameter by vkaranam for bug #5989740
1267: p_factor_type varchar2 default null
1268: ) return number
1269: is

Line 1270: /* Modified cursor to use ap_invoice_lines_all for Bug# 4445989 */

1266: --added the following parameter by vkaranam for bug #5989740
1267: p_factor_type varchar2 default null
1268: ) return number
1269: is
1270: /* Modified cursor to use ap_invoice_lines_all for Bug# 4445989 */
1271: cursor c_get_inv_details is
1272: select quantity_invoiced, unit_price, po_distribution_id, rcv_transaction_id,invoice_id
1273: from ap_invoice_lines_all
1274: where invoice_id = pn_invoice_id

Line 1273: from ap_invoice_lines_all

1269: is
1270: /* Modified cursor to use ap_invoice_lines_all for Bug# 4445989 */
1271: cursor c_get_inv_details is
1272: select quantity_invoiced, unit_price, po_distribution_id, rcv_transaction_id,invoice_id
1273: from ap_invoice_lines_all
1274: where invoice_id = pn_invoice_id
1275: AND line_number = pn_invoice_line_number;
1276:
1277: cursor c_get_uoms_po_receipt(p_rcv_transaction_id number) is

Line 2761: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;

2757: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2758: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2759: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2760:
2761: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2762: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2763: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2764: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;
2765: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;

Line 2762: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;

2758: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2759: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2760:
2761: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2762: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2763: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2764: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%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;

Line 2763: lv_match_type ap_invoice_lines_all.match_type%TYPE;

2759: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2760:
2761: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2762: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2763: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2764: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%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;

Line 2764: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;

2760:
2761: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2762: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2763: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2764: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%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:

Line 2765: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;

2761: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2762: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2763: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2764: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%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;

Line 2766: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;

2762: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2763: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2764: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%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;

Line 2767: ln_item_line_amt ap_invoice_lines_all.amount%TYPE;

2763: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2764: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%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;

Line 2902: , ap_invoice_lines_all aila

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
2906: AND aila.line_type_lookup_code = 'ITEM';

Line 2930: ap_invoice_lines_all

2926: , ln_po_dist_id
2927: , ln_po_loc_id
2928: , ln_item_line_amt
2929: FROM
2930: ap_invoice_lines_all
2931: WHERE invoice_id = pn_invoice_id
2932: AND line_number = ln_invoice_line_num;
2933:
2934: -- Get inv_organization_id and inv_organization_code