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 MTL_SYSTEM_ITEMS_KFV

Line 1658: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;

1654:
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);

Line 1724: mtl_system_items_kfv msi,

1720: null SPLIT
1721: from
1722: po_change_requests pcr,
1723: po_lines_archive_all pla,
1724: mtl_system_items_kfv msi,
1725: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1726: where pla.po_line_id = pcr.document_line_id
1727: and pcr.change_request_group_id =grp_id
1728: and pcr.request_level = 'LINE'

Line 1766: mtl_system_items_kfv msi,

1762: po_change_requests pcr,
1763: po_lines_archive_all pla,
1764: po_line_locations_archive_all plla,
1765: hr_locations_all hla, hz_locations hz,
1766: mtl_system_items_kfv msi,
1767: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1768: where pcr.change_request_group_id =grp_id
1769: and pla.po_line_id = pcr.document_line_id
1770: and pla.latest_external_flag = 'Y'

Line 1812: mtl_system_items_kfv msi,

1808: po_change_requests pcr,
1809: po_lines_archive_all pla,
1810: po_line_locations_archive_all plla,
1811: hr_locations_all hla, hz_locations hz,
1812: mtl_system_items_kfv msi,
1813: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1814: where pcr.change_request_group_id =grp_id
1815: and pla.po_line_id = pcr.document_line_id
1816: and pla.latest_external_flag = 'Y'

Line 2488: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;

2484: /*varchar Variables for creating the notification*/
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);

Line 2557: mtl_system_items_kfv msi,

2553: null SPLIT
2554: from
2555: po_change_requests pcr,
2556: po_lines_archive_all pla,
2557: mtl_system_items_kfv msi,
2558: mtl_planners mtp,
2559: financials_system_params_all fsp
2560: where pla.po_line_id = pcr.document_line_id
2561: and pcr.change_request_group_id =grp_id

Line 2601: mtl_system_items_kfv msi,

2597: po_change_requests pcr,
2598: po_lines_archive_all pla,
2599: po_line_locations_archive_all plla,
2600: hr_locations_all hla, hz_locations hz,
2601: mtl_system_items_kfv msi,
2602: mtl_planners mtp,
2603: financials_system_params_all fsp
2604: where pcr.change_request_group_id =grp_id
2605: and pla.po_line_id = pcr.document_line_id

Line 2650: mtl_system_items_kfv msi,

2646: po_change_requests pcr,
2647: po_lines_archive_all pla,
2648: po_line_locations_archive_all plla,
2649: hr_locations_all hla, hz_locations hz,
2650: mtl_system_items_kfv msi,
2651: mtl_planners mtp,
2652: financials_system_params_all fsp
2653: where pcr.change_request_group_id =grp_id
2654: and pla.po_line_id = pcr.document_line_id

Line 3316: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;

3312:
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;

Line 3382: mtl_system_items_kfv msi,

3378: null SPLIT
3379: from
3380: po_change_requests pcr,
3381: po_lines_archive_all pla,
3382: mtl_system_items_kfv msi,
3383: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3384: where pla.po_line_id = pcr.document_line_id
3385: and pcr.change_request_group_id =grp_id
3386: and pcr.request_level = 'LINE'

Line 3421: mtl_system_items_kfv msi,

3417: po_change_requests pcr,
3418: po_lines_archive_all pla,
3419: po_line_locations_archive_all plla,
3420: hr_locations_all hla, hz_locations hz,
3421: mtl_system_items_kfv msi,
3422: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3423: where pcr.change_request_group_id =grp_id
3424: and pla.po_line_id = pcr.document_line_id
3425: and pla.latest_external_flag = 'Y'

Line 3464: mtl_system_items_kfv msi,

3460: po_change_requests pcr,
3461: po_lines_archive_all pla,
3462: po_line_locations_archive_all plla,
3463: hr_locations_all hla, hz_locations hz,
3464: mtl_system_items_kfv msi,
3465: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3466: where pcr.change_request_group_id =grp_id
3467: and pla.po_line_id = pcr.document_line_id
3468: and pla.latest_external_flag = 'Y'

Line 3526: mtl_system_items_kfv msi,

3522: po_acceptances pa,
3523: po_lines_archive_all pla,
3524: po_line_locations_archive_all plla,
3525: hr_locations_all hla, hz_locations hz,
3526: mtl_system_items_kfv msi,
3527: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3528: where plla.po_header_id = l_po_document_id
3529: and plla.po_line_id = pla.po_line_id
3530: and pa.po_line_location_id = plla.line_location_id

Line 3569: mtl_system_items_kfv msi,

3565: po_acceptances pa,
3566: po_lines_archive_all pla,
3567: po_line_locations_archive_all plla,
3568: hr_locations_all hla, hz_locations hz,
3569: mtl_system_items_kfv msi,
3570: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3571: where plla.po_release_id = l_rel_document_id
3572: and plla.po_line_id = pla.po_line_id
3573: and pa.po_line_location_id = plla.line_location_id