APPS.ICX_CAT_UTIL_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 904: FROM mtl_system_items_b msi, financials_system_params_all fsp

900: --bug 15978590: add to check whether the item can be purchased or not
901: ELSIF (l_item_id IS NOT NULL) THEN
902: SELECT COUNT(*)
903: INTO l_status
904: FROM mtl_system_items_b msi, financials_system_params_all fsp
905: WHERE msi.INVENTORY_ITEM_ID = l_item_id
906: AND msi.ORGANIZATION_ID = fsp.INVENTORY_ORGANIZATION_ID
907: AND fsp.ORG_ID = p_org_id
908: AND (msi.purchasing_enabled_flag = 'Y'

Line 981: financials_system_params_all fsp

977: --Bug:#14370992 begin
978: AND Decode (pl.item_id, NULL, 1,
979: (SELECT Count(*)
980: FROM mtl_system_items_b msi,
981: financials_system_params_all fsp
982: WHERE msi.INVENTORY_ITEM_ID = pl.ITEM_ID
983: AND msi.ORGANIZATION_ID = fsp.INVENTORY_ORGANIZATION_ID
984: AND p_org_id = fsp.ORG_ID
985: AND (msi.purchasing_enabled_flag = 'Y'

Line 1014: financials_system_params_all fsp

1010: AND TRUNC(SYSDATE) <= NVL(TRUNC(pl.expiration_date), TRUNC( SYSDATE+1))
1011: AND Decode (pl.item_id, NULL, 1,
1012: (SELECT Count(*)
1013: FROM mtl_system_items_b msi,
1014: financials_system_params_all fsp
1015: WHERE msi.INVENTORY_ITEM_ID = pl.ITEM_ID
1016: AND msi.ORGANIZATION_ID = fsp.INVENTORY_ORGANIZATION_ID
1017: AND p_org_id = fsp.ORG_ID --Bug:#14370992
1018: AND (msi.purchasing_enabled_flag = 'Y'

Line 1072: financials_system_params_all fsp

1068: AND NVL(pqa.end_date_active, SYSDATE+1))))
1069: AND TRUNC(SYSDATE) < NVL(TRUNC(pl.expiration_date), TRUNC( SYSDATE+1))
1070: AND 1 = CASE WHEN pl.item_id IS NOT NULL THEN (SELECT Count(*)
1071: FROM mtl_system_items_b msi,
1072: financials_system_params_all fsp
1073: WHERE msi.INVENTORY_ITEM_ID = pl.ITEM_ID
1074: AND msi.ORGANIZATION_ID = fsp.INVENTORY_ORGANIZATION_ID
1075: AND pl.org_id = fsp.ORG_ID
1076: AND (msi.purchasing_enabled_flag = 'Y'