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 22: - Code modified to fetch the details from ap_invoice_lines_all

18:
19: 23-Jun-2005 Brathod , File Version 112.0 , Bug# 4445989
20: - Signature for procedure get_aportion_factor is modified to use invoice_id and
21: invoice_line_number
22: - Code modified to fetch the details from ap_invoice_lines_all
23: instead of ap_invoice_distributions_all
24:
25: 02-Sep-2005 Ramananda for Bug#4584221, File Version 120.2
26: Added the new function get_tds_invoice_batch

Line 1475: pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE

1471:
1472: /* Brathod, For Bug# 4445989, get_apportion_factor signature is modified to use invoice_id and line_number*/
1473: FUNCTION get_apportion_factor(
1474: -- p_invoice_distribution_id in number
1475: pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE
1476: , pn_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE,
1477: --added the following parameter by vkaranam for bug #5989740
1478: p_factor_type varchar2 default null
1479: ) return number

Line 1476: , pn_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE,

1472: /* Brathod, For Bug# 4445989, get_apportion_factor signature is modified to use invoice_id and line_number*/
1473: FUNCTION get_apportion_factor(
1474: -- p_invoice_distribution_id in number
1475: pn_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE
1476: , pn_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE,
1477: --added the following parameter by vkaranam for bug #5989740
1478: p_factor_type varchar2 default null
1479: ) return number
1480: is

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

1477: --added the following parameter by vkaranam for bug #5989740
1478: p_factor_type varchar2 default null
1479: ) return number
1480: is
1481: /* Modified cursor to use ap_invoice_lines_all for Bug# 4445989 */
1482: cursor c_get_inv_details is
1483: select quantity_invoiced, unit_price, po_distribution_id, rcv_transaction_id,invoice_id
1484: from ap_invoice_lines_all
1485: where invoice_id = pn_invoice_id

Line 1484: from ap_invoice_lines_all

1480: is
1481: /* Modified cursor to use ap_invoice_lines_all for Bug# 4445989 */
1482: cursor c_get_inv_details is
1483: select quantity_invoiced, unit_price, po_distribution_id, rcv_transaction_id,invoice_id
1484: from ap_invoice_lines_all
1485: where invoice_id = pn_invoice_id
1486: AND line_number = pn_invoice_line_number;
1487:
1488: cursor c_get_uoms_po_receipt(p_rcv_transaction_id number) is

Line 1511: from ap_invoice_lines_all

1507: from po_line_locations_all
1508: where (po_header_id, po_line_id, line_location_id ) in
1509: (
1510: select po_header_id, po_line_id, po_line_location_id
1511: from ap_invoice_lines_all
1512: where invoice_id = pn_invoice_id
1513: AND line_number = pn_invoice_line_number
1514: );
1515:

Line 2986: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;

2982: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2983: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2984: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2985:
2986: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2987: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2988: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2989: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;
2990: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;

Line 2987: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;

2983: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2984: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2985:
2986: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2987: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2988: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2989: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;
2990: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;
2991: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;

Line 2988: lv_match_type ap_invoice_lines_all.match_type%TYPE;

2984: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2985:
2986: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2987: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2988: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2989: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;
2990: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;
2991: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;
2992: ln_item_line_amt ap_invoice_lines_all.amount%TYPE;

Line 2989: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;

2985:
2986: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2987: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2988: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2989: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;
2990: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;
2991: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;
2992: ln_item_line_amt ap_invoice_lines_all.amount%TYPE;
2993:

Line 2990: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;

2986: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2987: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2988: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2989: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;
2990: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;
2991: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;
2992: ln_item_line_amt ap_invoice_lines_all.amount%TYPE;
2993:
2994: ln_invoice_line_num ap_invoice_distributions_all.invoice_line_number%TYPE;

Line 2991: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;

2987: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2988: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2989: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;
2990: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;
2991: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;
2992: ln_item_line_amt ap_invoice_lines_all.amount%TYPE;
2993:
2994: ln_invoice_line_num ap_invoice_distributions_all.invoice_line_number%TYPE;
2995: lv_inclu_tax_flag jai_ap_tds_years.inclusive_tax_flag%TYPE;

Line 2992: ln_item_line_amt ap_invoice_lines_all.amount%TYPE;

2988: lv_match_type ap_invoice_lines_all.match_type%TYPE;
2989: ln_set_of_books_id ap_invoice_lines_all.set_of_books_id%TYPE;
2990: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%TYPE;
2991: ln_po_loc_id ap_invoice_lines_all.po_line_location_id%TYPE;
2992: ln_item_line_amt ap_invoice_lines_all.amount%TYPE;
2993:
2994: ln_invoice_line_num ap_invoice_distributions_all.invoice_line_number%TYPE;
2995: lv_inclu_tax_flag jai_ap_tds_years.inclusive_tax_flag%TYPE;
2996: ln_inv_org_id mtl_parameters.organization_id%TYPE;

Line 3127: , ap_invoice_lines_all aila

3123: INTO
3124: ln_invoice_line_num
3125: FROM
3126: ap_invoice_distributions_all aida
3127: , ap_invoice_lines_all aila
3128: WHERE aida.invoice_distribution_id = pn_invoice_distribution_id
3129: AND aila.line_number = aida.invoice_line_number
3130: AND aila.invoice_id = pn_invoice_id
3131: AND aila.line_type_lookup_code = 'ITEM';

Line 3155: ap_invoice_lines_all

3151: , ln_po_dist_id
3152: , ln_po_loc_id
3153: , ln_item_line_amt
3154: FROM
3155: ap_invoice_lines_all
3156: WHERE invoice_id = pn_invoice_id
3157: AND line_number = ln_invoice_line_num;
3158:
3159: -- Get inv_organization_id and inv_organization_code