DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on PO_LINES_ALL

Line 1659: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;

1655: /*varchar Variables for creating the notification*/
1656: lc_line_num varchar2(2000);
1657: lc_ship_num varchar2(2000);
1658: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;
1659: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
1660: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
1661: lc_old_prom_date varchar2(2000);
1662: lc_new_prom_date varchar2(2000);
1663: lc_old_qty varchar2(2000);

Line 1668: lc_item_desc po_lines_all.item_description%TYPE;

1664: lc_new_qty varchar2(2000);
1665: lc_old_price varchar2(2000);
1666: lc_new_price varchar2(2000);
1667: lc_action_type varchar2(2000);
1668: lc_item_desc po_lines_all.item_description%TYPE;
1669: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
1670: lc_ship_to_location hr_locations_all.location_code%TYPE;
1671: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
1672: lc_reason po_change_requests.request_reason%TYPE;

Line 1669: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;

1665: lc_old_price varchar2(2000);
1666: lc_new_price varchar2(2000);
1667: lc_action_type varchar2(2000);
1668: lc_item_desc po_lines_all.item_description%TYPE;
1669: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
1670: lc_ship_to_location hr_locations_all.location_code%TYPE;
1671: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
1672: lc_reason po_change_requests.request_reason%TYPE;
1673: lc_split varchar2(2000);

Line 2489: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;

2485: lc_change_id number;
2486: lc_line_num varchar2(2000);
2487: lc_ship_num varchar2(2000);
2488: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;
2489: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
2490: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
2491: lc_old_prom_date varchar2(2000);
2492: lc_new_prom_date varchar2(2000);
2493: lc_old_qty varchar2(2000);

Line 2498: lc_item_desc po_lines_all.item_description%TYPE;

2494: lc_new_qty varchar2(2000);
2495: lc_old_price varchar2(2000);
2496: lc_new_price varchar2(2000);
2497: lc_action_type varchar2(2000);
2498: lc_item_desc po_lines_all.item_description%TYPE;
2499: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
2500: lc_ship_to_location hr_locations_all.location_code%TYPE;
2501: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
2502: lc_reason po_change_requests.request_reason%TYPE;

Line 2499: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;

2495: lc_old_price varchar2(2000);
2496: lc_new_price varchar2(2000);
2497: lc_action_type varchar2(2000);
2498: lc_item_desc po_lines_all.item_description%TYPE;
2499: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
2500: lc_ship_to_location hr_locations_all.location_code%TYPE;
2501: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
2502: lc_reason po_change_requests.request_reason%TYPE;
2503: lc_split varchar2(2000);

Line 3317: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;

3313: /*varchar Variables for creating the notification*/
3314: /* lc_line_num varchar2(2000);
3315: lc_ship_num varchar2(2000);
3316: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;
3317: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
3318: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
3319: lc_old_prom_date date;
3320: lc_new_prom_date date;
3321: lc_old_qty varchar2(2000);

Line 3326: lc_item_desc po_lines_all.item_description%TYPE;

3322: lc_new_qty varchar2(2000);
3323: lc_old_price varchar2(2000);
3324: lc_new_price varchar2(2000);
3325: lc_action_type varchar2(2000);
3326: lc_item_desc po_lines_all.item_description%TYPE;
3327: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
3328: lc_ship_to_location hr_locations_all.location_code%TYPE;
3329: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
3330: lc_reason po_change_requests.request_reason%TYPE;

Line 3327: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;

3323: lc_old_price varchar2(2000);
3324: lc_new_price varchar2(2000);
3325: lc_action_type varchar2(2000);
3326: lc_item_desc po_lines_all.item_description%TYPE;
3327: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
3328: lc_ship_to_location hr_locations_all.location_code%TYPE;
3329: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
3330: lc_reason po_change_requests.request_reason%TYPE;
3331: lc_split varchar2(2000);

Line 4393: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;

4389: l_doc_hdr_info varchar2(2000);
4390: lc_action_code po_change_requests.action_type%type;
4391: lc_line_num varchar2(2000);
4392: lc_ship_num varchar2(2000);
4393: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
4394: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
4395: lc_old_prom_date date;
4396: lc_new_prom_date date;
4397: lc_old_qty varchar2(2000);

Line 4402: lc_item_desc po_lines_all.item_description%TYPE;

4398: lc_new_qty varchar2(2000);
4399: lc_old_price varchar2(2000);
4400: lc_new_price varchar2(2000);
4401: lc_response varchar2(2000);
4402: lc_item_desc po_lines_all.item_description%TYPE;
4403: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
4404: lc_ship_to_location hr_locations_all.location_code%TYPE;
4405: lc_reason po_change_requests.response_reason%TYPE;
4406: lc_split varchar2(2000);

Line 4403: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;

4399: lc_old_price varchar2(2000);
4400: lc_new_price varchar2(2000);
4401: lc_response varchar2(2000);
4402: lc_item_desc po_lines_all.item_description%TYPE;
4403: lc_uom po_lines_all.unit_meas_lookup_code%TYPE;
4404: lc_ship_to_location hr_locations_all.location_code%TYPE;
4405: lc_reason po_change_requests.response_reason%TYPE;
4406: lc_split varchar2(2000);
4407:

Line 7628: po_lines_all pla,

7624: from
7625: mtl_system_items msi,
7626: mtl_planners mtp,
7627: po_change_requests pcr,
7628: po_lines_all pla,
7629: financials_system_params_all fsp
7630: where pcr.change_request_group_id = grp_id
7631: and pcr.document_line_id = pla.po_line_id
7632: and pla.item_id = msi.inventory_item_id