DBA Data[Home] [Help]

APPS.OKC_XPRT_OM_INT_PVT dependencies on MTL_ITEM_CATEGORIES_V

Line 1134: FROM mtl_item_categories_v

1130: --
1131: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
1132: cp_inventory_item_id NUMBER) IS
1133: SELECT category_concat_segs
1134: FROM mtl_item_categories_v
1135: WHERE inventory_item_id = cp_inventory_item_id
1136: AND organization_id = cp_org_id -- should be inventory master org
1137: AND structure_id = 101; -- hardcoded to 101 i.e. Item Categories(Inv.Items) for OM
1138:

Line 1516: FROM mtl_item_categories_v

1512: --
1513: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
1514: cp_inventory_item_id NUMBER) IS
1515: SELECT category_concat_segs
1516: FROM mtl_item_categories_v
1517: WHERE inventory_item_id = cp_inventory_item_id
1518: AND organization_id = cp_org_id -- should be inventory master org
1519: AND structure_id = 101; -- hardcoded to 101 i.e. Item Categories(Inv.Items) for OM
1520: