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_CMN_ST_FORMS_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 43: from JAI_AP_MATCH_INV_TAXES

39: cursor c_get_distrib_tax_details (p_invoice_id number, p_line_number number) IS /* p_distribution_no --uptake of ap_invoice_lines_all */
40: select tax_id, line_location_id, po_header_id, po_line_id, tax_amount,
41: parent_invoice_line_number --parent_invoice_distribution_id /* uptake of ap_invoice_lines_all */
42: ,recoverable_flag -- 5763527
43: from JAI_AP_MATCH_INV_TAXES
44: where invoice_id = p_invoice_id
45: and invoice_line_number = p_line_number; /* uptake of ap_invoice_lines_all */
46: /* and distribution_line_number = p_distribution_no;*/
47:

Line 55: lv_recoverable_flag JAI_AP_MATCH_INV_TAXES.recoverable_flag%type ;-- 5763527

51: from JAI_CMN_TAXES_ALL
52: where tax_id = p_tax_id;
53:
54: v_mod_cr_pctg JAI_CMN_TAXES_ALL.mod_cr_percentage%type ;-- 5763527
55: lv_recoverable_flag JAI_AP_MATCH_INV_TAXES.recoverable_flag%type ;-- 5763527
56:
57:
58: cursor c_get_ven_info(p_invoice_id number) is
59: select vendor_id, vendor_site_id, org_id

Line 143: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;

139: Changed the variable declaration from reference to ja_in_po_st_forms_hdr.form_issue_id to JAI_CMN_STFORM_HDRS_ALL.st_hdr_id.
140: This was required as the table ja_in_po_st_forms_hdr has been obsoleted.
141: */
142: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_id%type;
143: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
144: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
145: v_po_num po_headers_all.segment1%type;
146: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
147: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;

Line 144: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;

140: This was required as the table ja_in_po_st_forms_hdr has been obsoleted.
141: */
142: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_id%type;
143: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
144: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
145: v_po_num po_headers_all.segment1%type;
146: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
147: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
148: v_match_option po_line_locations_all.match_option%type;

Line 146: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;

142: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_id%type;
143: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
144: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
145: v_po_num po_headers_all.segment1%type;
146: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
147: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
148: v_match_option po_line_locations_all.match_option%type;
149: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
150: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;

Line 152: v_tax_amount JAI_AP_MATCH_INV_TAXES.tax_amount%type;

148: v_match_option po_line_locations_all.match_option%type;
149: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
150: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
151: v_type_lookup_code po_headers_all.type_lookup_code%type;
152: v_tax_amount JAI_AP_MATCH_INV_TAXES.tax_amount%type;
153: v_doc_type varchar2(10);
154: v_tax_target_amount number;
155: v_st_dtl_id number;
156: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;

Line 177: v_parent_invoice_line_number JAI_AP_MATCH_INV_TAXES.parent_invoice_line_number%type ;

173: v_invoice_process_flag char(1);
174: v_not_processed_inv_cnt number;
175:
176: lv_lt_lookup_code ap_invoice_distributions_all.line_type_lookup_code%type ;
177: v_parent_invoice_line_number JAI_AP_MATCH_INV_TAXES.parent_invoice_line_number%type ;
178:
179:
180: function getSTformsTaxBaseAmount /* uptake of ap_invoice_lines_all*/
181: (

Line 260: from JAI_AP_MATCH_INV_TAXES

256: from ap_invoice_lines_all
257: where invoice_id = p_invoice_id
258: and line_number in
259: ( select invoice_line_number
260: from JAI_AP_MATCH_INV_TAXES
261: where invoice_id = p_invoice_id
262: and po_header_id = p_po_header_id
263: and po_line_id = p_po_line_id
264: and line_location_id = p_line_location_id

Line 287: from jai_ap_match_inv_taxes

283: c_line_location_id NUMBER,
284: c_po_distribution_id NUMBER)
285: IS
286: select SUM(base_amount)
287: from jai_ap_match_inv_taxes
288: where invoice_id = c_invoice_id
289: and parent_invoice_distribution_id = c_invoice_distribution_id
290: and po_header_id = c_po_header_id
291: and po_line_id = c_po_line_id

Line 471: from JAI_AP_MATCH_INV_TAXES

467: or
468: (p_vendor_site_id is not null and vendor_site_id = p_vendor_site_id)
469: )
470: and exists (select '1'
471: from JAI_AP_MATCH_INV_TAXES
472: where invoice_id = a.invoice_id
473: and tax_id in (select tax_id from JAI_CMN_TAXES_ALL where stform_type is not null)
474: ) -- to ensure that loc taxes exists for the invoice and are of st forms type.
475:

Line 622: from JAI_AP_MATCH_INV_TAXES

618: ) -- to ensure that the line is not processed twice.
619: -- This should not happen as the invoice is already checked for prior processing.
620: and exists
621: (select '1'
622: from JAI_AP_MATCH_INV_TAXES
623: where invoice_id = b.invoice_id
624: --and distribution_line_number = b.distribution_line_number
625: and invoice_line_number = b.line_number
626: and tax_id in (select tax_id from JAI_CMN_TAXES_ALL where stform_type is not null)

Line 637: -- get the tax id for the distribution line from table JAI_AP_MATCH_INV_TAXES

633:
634:
635: begin
636:
637: -- get the tax id for the distribution line from table JAI_AP_MATCH_INV_TAXES
638:
639: v_tax_id := null;
640: v_tax_type := null;
641: v_tax_rate := null;