APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_CATEGORIES_B

Line 103: FROM mtl_categories_b

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

Line 618: FROM mtl_categories_b

614:
615: CURSOR category_exists_csr (p_category_id NUMBER)
616: IS
617: SELECT structure_id
618: FROM mtl_categories_b
619: WHERE category_id = p_category_id;
620:
621: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
622:

Line 1116: FROM mtl_categories_b

1112:
1113: CURSOR category_exists_csr (p_category_id NUMBER)
1114: IS
1115: SELECT structure_id
1116: FROM mtl_categories_b
1117: WHERE category_id = p_category_id
1118: AND NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE; /*Bug no: 5946409 Checking whether the category is disabled */
1119:
1120: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);