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.QPR_LOAD_MEAS_DATA dependencies on QPR_PN_LINES

Line 2030: l_org_id qpr_pn_lines.ORG_ID%type;

2026: r_hdr qpr_pn_int_headers%rowtype;
2027: r_lines qpr_pn_int_lines%rowtype;
2028: l_hdr_matching boolean := false;
2029: l_line_matching boolean := false;
2030: l_org_id qpr_pn_lines.ORG_ID%type;
2031: l_item_id qpr_pn_lines.inventory_item_id%type;
2032: l_pt_id qpr_pn_lines.payment_term_id%type;
2033: l_shm_code qpr_pn_lines.ship_method_code%type;
2034: l_geo_id qpr_pn_lines.geography_id%type;

Line 2031: l_item_id qpr_pn_lines.inventory_item_id%type;

2027: r_lines qpr_pn_int_lines%rowtype;
2028: l_hdr_matching boolean := false;
2029: l_line_matching boolean := false;
2030: l_org_id qpr_pn_lines.ORG_ID%type;
2031: l_item_id qpr_pn_lines.inventory_item_id%type;
2032: l_pt_id qpr_pn_lines.payment_term_id%type;
2033: l_shm_code qpr_pn_lines.ship_method_code%type;
2034: l_geo_id qpr_pn_lines.geography_id%type;
2035: l_uom_code qpr_pn_lines.uom_code%type;

Line 2032: l_pt_id qpr_pn_lines.payment_term_id%type;

2028: l_hdr_matching boolean := false;
2029: l_line_matching boolean := false;
2030: l_org_id qpr_pn_lines.ORG_ID%type;
2031: l_item_id qpr_pn_lines.inventory_item_id%type;
2032: l_pt_id qpr_pn_lines.payment_term_id%type;
2033: l_shm_code qpr_pn_lines.ship_method_code%type;
2034: l_geo_id qpr_pn_lines.geography_id%type;
2035: l_uom_code qpr_pn_lines.uom_code%type;
2036: l_ord_qty qpr_pn_lines.ordered_qty%type;

Line 2033: l_shm_code qpr_pn_lines.ship_method_code%type;

2029: l_line_matching boolean := false;
2030: l_org_id qpr_pn_lines.ORG_ID%type;
2031: l_item_id qpr_pn_lines.inventory_item_id%type;
2032: l_pt_id qpr_pn_lines.payment_term_id%type;
2033: l_shm_code qpr_pn_lines.ship_method_code%type;
2034: l_geo_id qpr_pn_lines.geography_id%type;
2035: l_uom_code qpr_pn_lines.uom_code%type;
2036: l_ord_qty qpr_pn_lines.ordered_qty%type;
2037: l_price qpr_pn_lines.proposed_price%type;

Line 2034: l_geo_id qpr_pn_lines.geography_id%type;

2030: l_org_id qpr_pn_lines.ORG_ID%type;
2031: l_item_id qpr_pn_lines.inventory_item_id%type;
2032: l_pt_id qpr_pn_lines.payment_term_id%type;
2033: l_shm_code qpr_pn_lines.ship_method_code%type;
2034: l_geo_id qpr_pn_lines.geography_id%type;
2035: l_uom_code qpr_pn_lines.uom_code%type;
2036: l_ord_qty qpr_pn_lines.ordered_qty%type;
2037: l_price qpr_pn_lines.proposed_price%type;
2038: l_curr_code qpr_pn_lines.currency_code%type;

Line 2035: l_uom_code qpr_pn_lines.uom_code%type;

2031: l_item_id qpr_pn_lines.inventory_item_id%type;
2032: l_pt_id qpr_pn_lines.payment_term_id%type;
2033: l_shm_code qpr_pn_lines.ship_method_code%type;
2034: l_geo_id qpr_pn_lines.geography_id%type;
2035: l_uom_code qpr_pn_lines.uom_code%type;
2036: l_ord_qty qpr_pn_lines.ordered_qty%type;
2037: l_price qpr_pn_lines.proposed_price%type;
2038: l_curr_code qpr_pn_lines.currency_code%type;
2039: l_quote_changed varchar2(1);

Line 2036: l_ord_qty qpr_pn_lines.ordered_qty%type;

2032: l_pt_id qpr_pn_lines.payment_term_id%type;
2033: l_shm_code qpr_pn_lines.ship_method_code%type;
2034: l_geo_id qpr_pn_lines.geography_id%type;
2035: l_uom_code qpr_pn_lines.uom_code%type;
2036: l_ord_qty qpr_pn_lines.ordered_qty%type;
2037: l_price qpr_pn_lines.proposed_price%type;
2038: l_curr_code qpr_pn_lines.currency_code%type;
2039: l_quote_changed varchar2(1);
2040: l_sql varchar2(10000);

Line 2037: l_price qpr_pn_lines.proposed_price%type;

2033: l_shm_code qpr_pn_lines.ship_method_code%type;
2034: l_geo_id qpr_pn_lines.geography_id%type;
2035: l_uom_code qpr_pn_lines.uom_code%type;
2036: l_ord_qty qpr_pn_lines.ordered_qty%type;
2037: l_price qpr_pn_lines.proposed_price%type;
2038: l_curr_code qpr_pn_lines.currency_code%type;
2039: l_quote_changed varchar2(1);
2040: l_sql varchar2(10000);
2041: l_line_cnt number;

Line 2038: l_curr_code qpr_pn_lines.currency_code%type;

2034: l_geo_id qpr_pn_lines.geography_id%type;
2035: l_uom_code qpr_pn_lines.uom_code%type;
2036: l_ord_qty qpr_pn_lines.ordered_qty%type;
2037: l_price qpr_pn_lines.proposed_price%type;
2038: l_curr_code qpr_pn_lines.currency_code%type;
2039: l_quote_changed varchar2(1);
2040: l_sql varchar2(10000);
2041: l_line_cnt number;
2042:

Line 2135: from qpr_pn_lines

2131: ORIG_SHIP_METHOD_CODE,
2132: GEOGRAPHY_ID,UOM_CODE,ORDERED_QTY,PROPOSED_PRICE,CURRENCY_CODE
2133: into l_org_id, l_item_id, l_pt_id, l_shm_code,
2134: l_geo_id, l_uom_code, l_ord_qty, l_price, l_curr_code
2135: from qpr_pn_lines
2136: where request_header_id = l_request_hdr_id
2137: and source_ref_line_id = r_lines.SOURCE_REF_LINE_ID
2138: and source_ref_hdr_id = r_lines.SOURCE_REF_HDR_ID
2139: and source_id = r_lines.SOURCE_ID

Line 2172: from qpr_pn_lines

2168: -- handle the case: header is matching- few lines have been deleted in
2169: -- source and the existing lines match.
2170: if l_quote_changed = 'N' then
2171: select count(*) into l_line_cnt
2172: from qpr_pn_lines
2173: where request_header_id = l_request_hdr_id
2174: and item_type_code <> 'DUMMY_PARENT';
2175:
2176: open c_ref for l_sql using p_src_quote_header_id;