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.PO_CHANGEORDERWF_PVT dependencies on PO_LINES_ALL

Line 1518: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;

1514: /*varchar Variables for creating the notification*/
1515: lc_line_num varchar2(2000);
1516: lc_ship_num varchar2(2000);
1517: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;
1518: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
1519: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
1520: lc_old_prom_date varchar2(2000);
1521: lc_new_prom_date varchar2(2000);
1522: lc_old_qty varchar2(2000);

Line 1527: lc_item_desc po_lines_all.item_description%TYPE;

1523: lc_new_qty varchar2(2000);
1524: lc_old_price varchar2(2000);
1525: lc_new_price varchar2(2000);
1526: lc_action_type varchar2(2000);
1527: lc_item_desc po_lines_all.item_description%TYPE;
1528: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
1529: lc_ship_to_location hr_locations_all.location_code%TYPE;
1530: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
1531: lc_reason po_change_requests.request_reason%TYPE;

Line 1528: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;

1524: lc_old_price varchar2(2000);
1525: lc_new_price varchar2(2000);
1526: lc_action_type varchar2(2000);
1527: lc_item_desc po_lines_all.item_description%TYPE;
1528: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
1529: lc_ship_to_location hr_locations_all.location_code%TYPE;
1530: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
1531: lc_reason po_change_requests.request_reason%TYPE;
1532: lc_split varchar2(2000);

Line 2341: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;

2337: lc_change_id number;
2338: lc_line_num varchar2(2000);
2339: lc_ship_num varchar2(2000);
2340: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;
2341: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
2342: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
2343: lc_old_prom_date varchar2(2000);
2344: lc_new_prom_date varchar2(2000);
2345: lc_old_qty varchar2(2000);

Line 2350: lc_item_desc po_lines_all.item_description%TYPE;

2346: lc_new_qty varchar2(2000);
2347: lc_old_price varchar2(2000);
2348: lc_new_price varchar2(2000);
2349: lc_action_type varchar2(2000);
2350: lc_item_desc po_lines_all.item_description%TYPE;
2351: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
2352: lc_ship_to_location hr_locations_all.location_code%TYPE;
2353: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
2354: lc_reason po_change_requests.request_reason%TYPE;

Line 2351: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;

2347: lc_old_price varchar2(2000);
2348: lc_new_price varchar2(2000);
2349: lc_action_type varchar2(2000);
2350: lc_item_desc po_lines_all.item_description%TYPE;
2351: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
2352: lc_ship_to_location hr_locations_all.location_code%TYPE;
2353: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
2354: lc_reason po_change_requests.request_reason%TYPE;
2355: lc_split varchar2(2000);

Line 3165: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;

3161: /*varchar Variables for creating the notification*/
3162: /* lc_line_num varchar2(2000);
3163: lc_ship_num varchar2(2000);
3164: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;
3165: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
3166: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
3167: lc_old_prom_date date;
3168: lc_new_prom_date date;
3169: lc_old_qty varchar2(2000);

Line 3174: lc_item_desc po_lines_all.item_description%TYPE;

3170: lc_new_qty varchar2(2000);
3171: lc_old_price varchar2(2000);
3172: lc_new_price varchar2(2000);
3173: lc_action_type varchar2(2000);
3174: lc_item_desc po_lines_all.item_description%TYPE;
3175: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
3176: lc_ship_to_location hr_locations_all.location_code%TYPE;
3177: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
3178: lc_reason po_change_requests.request_reason%TYPE;

Line 3175: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;

3171: lc_old_price varchar2(2000);
3172: lc_new_price varchar2(2000);
3173: lc_action_type varchar2(2000);
3174: lc_item_desc po_lines_all.item_description%TYPE;
3175: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
3176: lc_ship_to_location hr_locations_all.location_code%TYPE;
3177: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
3178: lc_reason po_change_requests.request_reason%TYPE;
3179: lc_split varchar2(2000);

Line 4241: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;

4237: l_doc_hdr_info varchar2(2000);
4238: lc_action_code po_change_requests.action_type%type;
4239: lc_line_num varchar2(2000);
4240: lc_ship_num varchar2(2000);
4241: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
4242: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
4243: lc_old_prom_date date;
4244: lc_new_prom_date date;
4245: lc_old_qty varchar2(2000);

Line 4250: lc_item_desc po_lines_all.item_description%TYPE;

4246: lc_new_qty varchar2(2000);
4247: lc_old_price varchar2(2000);
4248: lc_new_price varchar2(2000);
4249: lc_response varchar2(2000);
4250: lc_item_desc po_lines_all.item_description%TYPE;
4251: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
4252: lc_ship_to_location hr_locations_all.location_code%TYPE;
4253: lc_reason po_change_requests.response_reason%TYPE;
4254: lc_split varchar2(2000);

Line 4251: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;

4247: lc_old_price varchar2(2000);
4248: lc_new_price varchar2(2000);
4249: lc_response varchar2(2000);
4250: lc_item_desc po_lines_all.item_description%TYPE;
4251: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
4252: lc_ship_to_location hr_locations_all.location_code%TYPE;
4253: lc_reason po_change_requests.response_reason%TYPE;
4254: lc_split varchar2(2000);
4255:

Line 7470: po_lines_all pla,

7466: from
7467: mtl_system_items msi,
7468: mtl_planners mtp,
7469: po_change_requests pcr,
7470: po_lines_all pla,
7471: financials_system_params_all fsp
7472: where pcr.change_request_group_id = grp_id
7473: and pcr.document_line_id = pla.po_line_id
7474: and pla.item_id = msi.inventory_item_id