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 PO_LINE_LOCATIONS_ALL

Line 118: from po_line_locations_all

114: and line_location_id = p_po_line_location_id;
115:
116: cursor c_get_match_org_loc(p_po_line_location_id number) is
117: select match_option, ship_to_organization_id, ship_to_location_id
118: from po_line_locations_all
119: where line_location_id = p_po_line_location_id;
120:
121: /* Modified by Ramananda for bug# due to uptake of ap_invoice_lines_all */
122: cursor c_get_rcv_transaction_id(p_invoice_id number, p_po_distribution_id number, cp_lt_lookup_code ap_invoice_lines_all.line_type_lookup_code%type ) is

Line 164: v_match_option po_line_locations_all.match_option%type;

160: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
161: v_po_num po_headers_all.segment1%type;
162: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
163: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
164: v_match_option po_line_locations_all.match_option%type;
165: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
166: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
167: v_type_lookup_code po_headers_all.type_lookup_code%type;
168: v_tax_amount JAI_AP_MATCH_INV_TAXES.tax_amount%type;

Line 165: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;

161: v_po_num po_headers_all.segment1%type;
162: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
163: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
164: v_match_option po_line_locations_all.match_option%type;
165: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
166: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
167: v_type_lookup_code po_headers_all.type_lookup_code%type;
168: v_tax_amount JAI_AP_MATCH_INV_TAXES.tax_amount%type;
169: v_doc_type varchar2(10);

Line 166: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;

162: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
163: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
164: v_match_option po_line_locations_all.match_option%type;
165: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
166: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
167: v_type_lookup_code po_headers_all.type_lookup_code%type;
168: v_tax_amount JAI_AP_MATCH_INV_TAXES.tax_amount%type;
169: v_doc_type varchar2(10);
170: v_tax_target_amount number;