APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_CATEGORIES_B

Line 102: FROM mtl_categories_b

98:
99: CURSOR category_exists_csr (p_category_id NUMBER)
100: IS
101: SELECT structure_id
102: FROM mtl_categories_b
103: WHERE category_id = p_category_id
104: AND NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE;--Bug: 2996160
105:
106: CURSOR category_set_valid_cats_csr

Line 608: FROM mtl_categories_b

604:
605: CURSOR category_exists_csr (p_category_id NUMBER)
606: IS
607: SELECT structure_id
608: FROM mtl_categories_b
609: WHERE category_id = p_category_id;
610:
611: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
612:

Line 1104: FROM mtl_categories_b

1100:
1101: CURSOR category_exists_csr (p_category_id NUMBER)
1102: IS
1103: SELECT structure_id
1104: FROM mtl_categories_b
1105: WHERE category_id = p_category_id
1106: AND NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE; /*Bug no: 5946409 Checking whether the category is disabled */
1107:
1108: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);