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.ICX_POR_EXT_DIAG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 692: mtl_system_items_kfv mi

688: xCategoryId
689: FROM po_headers_all ph,
690: po_lines_all pl,
691: financials_system_params_all fsp,
692: mtl_system_items_kfv mi
693: WHERE ph.segment1 = pPONum
694: AND (ph.org_id is null and pOperatingUnitId is null or ph.org_id = pOperatingUnitId)
695: AND ph.type_lookup_code = pType
696: AND ph.po_header_id = pl.po_header_id

Line 780: mtl_system_items_kfv mi

776: xCategoryId
777: FROM po_reqexpress_headers_all prh,
778: po_reqexpress_lines_all prl,
779: financials_system_params_all fsp,
780: mtl_system_items_kfv mi
781: WHERE prh.express_name = pTemplateName
782: AND (prh.org_id is null and pOperatingUnitId is null or prh.org_id = pOperatingUnitId)
783: AND prl.express_name = prh.express_name
784: AND (prh.org_id is null and prl.org_id is null or prl.org_id = prh.org_id)

Line 872: mtl_system_items_kfv mi,

868: xOrgName
869: FROM po_approved_supplier_list pasl,
870: po_vendors pv,
871: financials_system_params_all fsp,
872: mtl_system_items_kfv mi,
873: mtl_item_categories mic,
874: hr_all_organization_units hr
875: WHERE pasl.asl_id = pASLId
876: AND (fsp.org_id is null and pOperatingUnitId is null or fsp.org_id = pOperatingUnitId)

Line 962: mtl_system_items_kfv mi,

958: xItemId,
959: xCategoryId,
960: xOrgName
961: FROM financials_system_params_all fsp,
962: mtl_system_items_kfv mi,
963: mtl_item_categories mic,
964: hr_all_organization_units hr
965: WHERE (fsp.org_id is null and pOperatingUnitId is null or fsp.org_id = pOperatingUnitId)
966: AND fsp.inventory_organization_id = mi.organization_id

Line 1464: 'imtl_system_items_kfv mi, ' ||

1460: IF p_test_mode = 'Y' THEN
1461: xString := xString ||
1462: 'ipo_headers_all ph, ' ||
1463: 'ipo_lines_all pl, ' ||
1464: 'imtl_system_items_kfv mi, ' ||
1465: 'ifinancials_system_params_all fsp ';
1466: ELSE
1467: xString := xString ||
1468: 'po_headers_all ph, ' ||

Line 1470: 'mtl_system_items_kfv mi, ' ||

1466: ELSE
1467: xString := xString ||
1468: 'po_headers_all ph, ' ||
1469: 'po_lines_all pl, ' ||
1470: 'mtl_system_items_kfv mi, ' ||
1471: 'financials_system_params_all fsp ';
1472: END IF;
1473: xString := xString ||
1474: 'WHERE pl.po_line_id = :contract_line_id ' ||

Line 1697: 'imtl_system_items_kfv mi, ' ||

1693: 'FROM ';
1694: IF p_test_mode = 'Y' THEN
1695: xString := xString ||
1696: 'ipo_reqexpress_lines_all prl, ' ||
1697: 'imtl_system_items_kfv mi, ' ||
1698: 'ifinancials_system_params_all fsp ' ;
1699: ELSE
1700: xString := xString ||
1701: 'po_reqexpress_lines_all prl, ' ||

Line 1702: 'mtl_system_items_kfv mi, ' ||

1698: 'ifinancials_system_params_all fsp ' ;
1699: ELSE
1700: xString := xString ||
1701: 'po_reqexpress_lines_all prl, ' ||
1702: 'mtl_system_items_kfv mi, ' ||
1703: 'financials_system_params_all fsp ';
1704: END IF;
1705:
1706: xString := xString ||

Line 1785: 'imtl_system_items_kfv mi ';

1781: 'FROM ';
1782: IF p_test_mode = 'Y' THEN
1783: xString := xString ||
1784: 'ipo_approved_supplier_list pasl, ' ||
1785: 'imtl_system_items_kfv mi ';
1786: ELSE
1787: xString := xString ||
1788: 'po_approved_supplier_list pasl, ' ||
1789: 'mtl_system_items_kfv mi ';

Line 1789: 'mtl_system_items_kfv mi ';

1785: 'imtl_system_items_kfv mi ';
1786: ELSE
1787: xString := xString ||
1788: 'po_approved_supplier_list pasl, ' ||
1789: 'mtl_system_items_kfv mi ';
1790: END IF;
1791: xString := xString ||
1792: 'WHERE pasl.asl_id = :asl_id ' ||
1793: ' AND pasl.item_id = mi.inventory_item_id ' ||

Line 1935: 'imtl_system_items_kfv mi, '||

1931: IF p_test_mode = 'Y' THEN
1932: xString := xString ||
1933: 'ipo_ga_org_assignments t, '||
1934: 'ipo_vendor_sites_all pvs, '||
1935: 'imtl_system_items_kfv mi, '||
1936: 'ifinancials_system_params_all fsp, '||
1937: 'imtl_system_items_kfv mi2, '|| -- Centralized proc Impacts
1938: 'ifinancials_system_params_all fsp2 ';
1939: ELSE

Line 1937: 'imtl_system_items_kfv mi2, '|| -- Centralized proc Impacts

1933: 'ipo_ga_org_assignments t, '||
1934: 'ipo_vendor_sites_all pvs, '||
1935: 'imtl_system_items_kfv mi, '||
1936: 'ifinancials_system_params_all fsp, '||
1937: 'imtl_system_items_kfv mi2, '|| -- Centralized proc Impacts
1938: 'ifinancials_system_params_all fsp2 ';
1939: ELSE
1940: xString := xString ||
1941: 'po_ga_org_assignments t, '||

Line 1943: 'mtl_system_items_kfv mi, '||

1939: ELSE
1940: xString := xString ||
1941: 'po_ga_org_assignments t, '||
1942: 'po_vendor_sites_all pvs, '||
1943: 'mtl_system_items_kfv mi, '||
1944: 'financials_system_params_all fsp, '||
1945: 'mtl_system_items_kfv mi2, '|| -- Centralized proc Impacts
1946: 'financials_system_params_all fsp2 ';
1947: END IF;

Line 1945: 'mtl_system_items_kfv mi2, '|| -- Centralized proc Impacts

1941: 'po_ga_org_assignments t, '||
1942: 'po_vendor_sites_all pvs, '||
1943: 'mtl_system_items_kfv mi, '||
1944: 'financials_system_params_all fsp, '||
1945: 'mtl_system_items_kfv mi2, '|| -- Centralized proc Impacts
1946: 'financials_system_params_all fsp2 ';
1947: END IF;
1948: xString := xString ||
1949: 'WHERE p.rowid = :row_id ' ||

Line 1994: 'imtl_system_items_kfv mi, '||

1990: 'FROM icx_cat_item_prices p, ';
1991: IF p_test_mode = 'Y' THEN
1992: xString := xString ||
1993: 'ipo_approved_supplier_list pasl, '||
1994: 'imtl_system_items_kfv mi, '||
1995: 'ifinancials_system_params_all fsp ';
1996: ELSE
1997: xString := xString ||
1998: 'po_approved_supplier_list pasl, '||

Line 1999: 'mtl_system_items_kfv mi, '||

1995: 'ifinancials_system_params_all fsp ';
1996: ELSE
1997: xString := xString ||
1998: 'po_approved_supplier_list pasl, '||
1999: 'mtl_system_items_kfv mi, '||
2000: 'financials_system_params_all fsp ';
2001: END IF;
2002: xString := xString ||
2003: 'WHERE p.rowid = :row_id ' ||

Line 2028: 'imtl_system_items_kfv mi, '||

2024: 'mi.list_price_per_unit '||
2025: 'FROM icx_cat_item_prices p, ';
2026: IF p_test_mode = 'Y' THEN
2027: xString := xString ||
2028: 'imtl_system_items_kfv mi, '||
2029: 'ifinancials_system_params_all fsp ';
2030: ELSE
2031: xString := xString ||
2032: 'mtl_system_items_kfv mi, '||

Line 2032: 'mtl_system_items_kfv mi, '||

2028: 'imtl_system_items_kfv mi, '||
2029: 'ifinancials_system_params_all fsp ';
2030: ELSE
2031: xString := xString ||
2032: 'mtl_system_items_kfv mi, '||
2033: 'financials_system_params_all fsp ';
2034: END IF;
2035: xString := xString ||
2036: 'WHERE p.rowid = :row_id ' ||

Line 2055: 'imtl_system_items_kfv mi, '||

2051: 'SELECT mi.internal_order_enabled_flag '||
2052: 'FROM icx_cat_item_prices p, ';
2053: IF p_test_mode = 'Y' THEN
2054: xString := xString ||
2055: 'imtl_system_items_kfv mi, '||
2056: 'ifinancials_system_params_all fsp ';
2057: ELSE
2058: xString := xString ||
2059: 'mtl_system_items_kfv mi, '||

Line 2059: 'mtl_system_items_kfv mi, '||

2055: 'imtl_system_items_kfv mi, '||
2056: 'ifinancials_system_params_all fsp ';
2057: ELSE
2058: xString := xString ||
2059: 'mtl_system_items_kfv mi, '||
2060: 'financials_system_params_all fsp ';
2061: END IF;
2062: xString := xString ||
2063: 'WHERE p.rowid = :row_id ' ||