DBA Data[Home] [Help]

APPS.OKC_XPRT_OM_INT_PVT dependencies on MTL_ITEM_CATEGORIES_V

Line 1397: FROM mtl_item_categories_v

1393: --
1394: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
1395: cp_inventory_item_id NUMBER) IS
1396: SELECT category_concat_segs
1397: FROM mtl_item_categories_v
1398: WHERE inventory_item_id = cp_inventory_item_id
1399: AND organization_id = cp_org_id -- should be inventory master org
1400: AND structure_id = 101; -- hardcoded to 101 i.e. Item Categories(Inv.Items) for OM
1401:

Line 1779: FROM mtl_item_categories_v

1775: --
1776: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
1777: cp_inventory_item_id NUMBER) IS
1778: SELECT category_concat_segs
1779: FROM mtl_item_categories_v
1780: WHERE inventory_item_id = cp_inventory_item_id
1781: AND organization_id = cp_org_id -- should be inventory master org
1782: AND structure_id = 101; -- hardcoded to 101 i.e. Item Categories(Inv.Items) for OM
1783: