APPS.OKL_FE_WF dependencies on OKL_ITM_CAT_RV_PRCS_V

Line 1598: OKL_ITM_CAT_RV_PRCS_V ICPV,

1594: ICPV.START_DATE,
1595: ICPV.END_DATE,
1596: ICPV.ID
1597: FROM OKL_FE_ITEM_RESIDUAL IRHV,
1598: OKL_ITM_CAT_RV_PRCS_V ICPV,
1599: MTL_SYSTEM_ITEMS_VL INV
1600: WHERE IRHV.INVENTORY_ITEM_ID = INV.INVENTORY_ITEM_ID
1601: AND IRHV.ORGANIZATION_ID = INV.ORGANIZATION_ID
1602: AND ICPV.ITEM_RESIDUAL_ID = IRHV.ITEM_RESIDUAL_ID

Line 1624: OKL_ITM_CAT_RV_PRCS_V ICPV,

1620: ICPV.START_DATE,
1621: ICPV.END_DATE,
1622: ICPV.ID
1623: FROM OKL_FE_ITEM_RESIDUAL IRHV,
1624: OKL_ITM_CAT_RV_PRCS_V ICPV,
1625: MTL_CATEGORIES_V INVCAT
1626: WHERE IRHV.CATEGORY_ID = INVCAT.CATEGORY_ID
1627: AND ICPV.ITEM_RESIDUAL_ID = IRHV.ITEM_RESIDUAL_ID
1628: AND ICPV.ID = p_itm_resdl_ver_id;

Line 1649: OKL_ITM_CAT_RV_PRCS_V ICPV,

1645: ICPV.START_DATE,
1646: ICPV.END_DATE,
1647: ICPV.ID
1648: FROM OKL_FE_ITEM_RESIDUAL IRHV,
1649: OKL_ITM_CAT_RV_PRCS_V ICPV,
1650: OKL_FE_RESI_CAT_V RCSV
1651: WHERE IRHV.RESI_CATEGORY_SET_ID = RCSV.RESI_CATEGORY_SET_ID
1652: AND ICPV.ITEM_RESIDUAL_ID = IRHV.ITEM_RESIDUAL_ID
1653: AND ICPV.ID = p_itm_resdl_ver_id;

Line 1671: OKL_ITM_CAT_RV_PRCS_V ICPV

1667:
1668: CURSOR c_get_cat_type(p_item_resdl_version_id NUMBER) IS
1669: SELECT IRHV.CATEGORY_TYPE_CODE
1670: FROM OKL_FE_ITEM_RESIDUAL IRHV,
1671: OKL_ITM_CAT_RV_PRCS_V ICPV
1672: WHERE IRHV.ITEM_RESIDUAL_ID = ICPV.ITEM_RESIDUAL_ID
1673: AND ICPV.ID = p_item_resdl_version_id; -- Item residual version ID
1674:
1675: BEGIN