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 2017: l_org_id qpr_pn_lines.ORG_ID%type;

2013: r_hdr qpr_pn_int_headers%rowtype;
2014: r_lines qpr_pn_int_lines%rowtype;
2015: l_hdr_matching boolean := false;
2016: l_line_matching boolean := false;
2017: l_org_id qpr_pn_lines.ORG_ID%type;
2018: l_item_id qpr_pn_lines.inventory_item_id%type;
2019: l_pt_id qpr_pn_lines.payment_term_id%type;
2020: l_shm_code qpr_pn_lines.ship_method_code%type;
2021: l_geo_id qpr_pn_lines.geography_id%type;

Line 2018: l_item_id qpr_pn_lines.inventory_item_id%type;

2014: r_lines qpr_pn_int_lines%rowtype;
2015: l_hdr_matching boolean := false;
2016: l_line_matching boolean := false;
2017: l_org_id qpr_pn_lines.ORG_ID%type;
2018: l_item_id qpr_pn_lines.inventory_item_id%type;
2019: l_pt_id qpr_pn_lines.payment_term_id%type;
2020: l_shm_code qpr_pn_lines.ship_method_code%type;
2021: l_geo_id qpr_pn_lines.geography_id%type;
2022: l_uom_code qpr_pn_lines.uom_code%type;

Line 2019: l_pt_id qpr_pn_lines.payment_term_id%type;

2015: l_hdr_matching boolean := false;
2016: l_line_matching boolean := false;
2017: l_org_id qpr_pn_lines.ORG_ID%type;
2018: l_item_id qpr_pn_lines.inventory_item_id%type;
2019: l_pt_id qpr_pn_lines.payment_term_id%type;
2020: l_shm_code qpr_pn_lines.ship_method_code%type;
2021: l_geo_id qpr_pn_lines.geography_id%type;
2022: l_uom_code qpr_pn_lines.uom_code%type;
2023: l_ord_qty qpr_pn_lines.ordered_qty%type;

Line 2020: l_shm_code qpr_pn_lines.ship_method_code%type;

2016: l_line_matching boolean := false;
2017: l_org_id qpr_pn_lines.ORG_ID%type;
2018: l_item_id qpr_pn_lines.inventory_item_id%type;
2019: l_pt_id qpr_pn_lines.payment_term_id%type;
2020: l_shm_code qpr_pn_lines.ship_method_code%type;
2021: l_geo_id qpr_pn_lines.geography_id%type;
2022: l_uom_code qpr_pn_lines.uom_code%type;
2023: l_ord_qty qpr_pn_lines.ordered_qty%type;
2024: l_price qpr_pn_lines.proposed_price%type;

Line 2021: l_geo_id qpr_pn_lines.geography_id%type;

2017: l_org_id qpr_pn_lines.ORG_ID%type;
2018: l_item_id qpr_pn_lines.inventory_item_id%type;
2019: l_pt_id qpr_pn_lines.payment_term_id%type;
2020: l_shm_code qpr_pn_lines.ship_method_code%type;
2021: l_geo_id qpr_pn_lines.geography_id%type;
2022: l_uom_code qpr_pn_lines.uom_code%type;
2023: l_ord_qty qpr_pn_lines.ordered_qty%type;
2024: l_price qpr_pn_lines.proposed_price%type;
2025: l_curr_code qpr_pn_lines.currency_code%type;

Line 2022: l_uom_code qpr_pn_lines.uom_code%type;

2018: l_item_id qpr_pn_lines.inventory_item_id%type;
2019: l_pt_id qpr_pn_lines.payment_term_id%type;
2020: l_shm_code qpr_pn_lines.ship_method_code%type;
2021: l_geo_id qpr_pn_lines.geography_id%type;
2022: l_uom_code qpr_pn_lines.uom_code%type;
2023: l_ord_qty qpr_pn_lines.ordered_qty%type;
2024: l_price qpr_pn_lines.proposed_price%type;
2025: l_curr_code qpr_pn_lines.currency_code%type;
2026: l_quote_changed varchar2(1);

Line 2023: l_ord_qty qpr_pn_lines.ordered_qty%type;

2019: l_pt_id qpr_pn_lines.payment_term_id%type;
2020: l_shm_code qpr_pn_lines.ship_method_code%type;
2021: l_geo_id qpr_pn_lines.geography_id%type;
2022: l_uom_code qpr_pn_lines.uom_code%type;
2023: l_ord_qty qpr_pn_lines.ordered_qty%type;
2024: l_price qpr_pn_lines.proposed_price%type;
2025: l_curr_code qpr_pn_lines.currency_code%type;
2026: l_quote_changed varchar2(1);
2027: l_sql varchar2(10000);

Line 2024: l_price qpr_pn_lines.proposed_price%type;

2020: l_shm_code qpr_pn_lines.ship_method_code%type;
2021: l_geo_id qpr_pn_lines.geography_id%type;
2022: l_uom_code qpr_pn_lines.uom_code%type;
2023: l_ord_qty qpr_pn_lines.ordered_qty%type;
2024: l_price qpr_pn_lines.proposed_price%type;
2025: l_curr_code qpr_pn_lines.currency_code%type;
2026: l_quote_changed varchar2(1);
2027: l_sql varchar2(10000);
2028: l_line_cnt number;

Line 2025: l_curr_code qpr_pn_lines.currency_code%type;

2021: l_geo_id qpr_pn_lines.geography_id%type;
2022: l_uom_code qpr_pn_lines.uom_code%type;
2023: l_ord_qty qpr_pn_lines.ordered_qty%type;
2024: l_price qpr_pn_lines.proposed_price%type;
2025: l_curr_code qpr_pn_lines.currency_code%type;
2026: l_quote_changed varchar2(1);
2027: l_sql varchar2(10000);
2028: l_line_cnt number;
2029:

Line 2122: from qpr_pn_lines

2118: ORIG_SHIP_METHOD_CODE,
2119: GEOGRAPHY_ID,UOM_CODE,ORDERED_QTY,PROPOSED_PRICE,CURRENCY_CODE
2120: into l_org_id, l_item_id, l_pt_id, l_shm_code,
2121: l_geo_id, l_uom_code, l_ord_qty, l_price, l_curr_code
2122: from qpr_pn_lines
2123: where request_header_id = l_request_hdr_id
2124: and source_ref_line_id = r_lines.SOURCE_REF_LINE_ID
2125: and source_ref_hdr_id = r_lines.SOURCE_REF_HDR_ID
2126: and source_id = r_lines.SOURCE_ID

Line 2159: from qpr_pn_lines

2155: -- handle the case: header is matching- few lines have been deleted in
2156: -- source and the existing lines match.
2157: if l_quote_changed = 'N' then
2158: select count(*) into l_line_cnt
2159: from qpr_pn_lines
2160: where request_header_id = l_request_hdr_id
2161: and item_type_code <> 'DUMMY_PARENT';
2162:
2163: open c_ref for l_sql using p_src_quote_header_id;