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 FINANCIALS_SYSTEM_PARAMS_ALL

Line 691: financials_system_params_all fsp,

687: xItemNum,
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

Line 779: financials_system_params_all fsp,

775: xItemNum,
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

Line 871: financials_system_params_all fsp,

867: xCategoryId,
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

Line 961: FROM financials_system_params_all fsp,

957: xStatus2,
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)

Line 1465: 'ifinancials_system_params_all fsp ';

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, ' ||
1469: 'po_lines_all pl, ' ||

Line 1471: 'financials_system_params_all fsp ';

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 ' ||
1475: ' AND ph.po_header_id = pl.po_header_id ' ||

Line 1698: 'ifinancials_system_params_all fsp ' ;

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, ' ||
1702: 'mtl_system_items_kfv mi, ' ||

Line 1703: 'financials_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 ||
1707: 'WHERE prl.express_name = :express_name ' ||

Line 1773: * So, we can remove the join with financials_system_params_all completely

1769: * Since the following query is only to find the validity of item in the ASL
1770: * AND ASLs are inventory org based and not OU based(which means to create
1771: * an ASL in an inventory org-INV1 the master item to be attached should be
1772: * enabled in INV1)
1773: * So, we can remove the join with financials_system_params_all completely
1774: */
1775: xString :=
1776: 'SELECT decode(mi.inventory_item_id, ' ||
1777: ' NULL, ' || VALID_FOR_EXTRACT || ', ' ||

Line 1936: 'ifinancials_system_params_all fsp, '||

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
1940: xString := xString ||

Line 1938: 'ifinancials_system_params_all fsp2 ';

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, '||
1942: 'po_vendor_sites_all pvs, '||

Line 1944: 'financials_system_params_all fsp, '||

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;
1948: xString := xString ||

Line 1946: 'financials_system_params_all fsp2 ';

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 ' ||
1950: 'AND p.contract_id = t.po_header_id '||

Line 1995: 'ifinancials_system_params_all fsp ';

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, '||
1999: 'mtl_system_items_kfv mi, '||

Line 2000: 'financials_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 ' ||
2004: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||

Line 2029: 'ifinancials_system_params_all fsp ';

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, '||
2033: 'financials_system_params_all fsp ';

Line 2033: 'financials_system_params_all fsp ';

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 ' ||
2037: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||

Line 2056: 'ifinancials_system_params_all fsp ';

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, '||
2060: 'financials_system_params_all fsp ';

Line 2060: 'financials_system_params_all fsp ';

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 ' ||
2064: 'AND p.org_id = nvl(fsp.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||