APPS.INVIDIT3 dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 1398: FROM mtl_item_catalog_groups_b icg

1394: l_child_catalog := 'N';
1395: IF new_catalog_group_id IS NOT NULL THEN
1396: BEGIN
1397: SELECT 'Y' INTO L_child_catalog
1398: FROM mtl_item_catalog_groups_b icg
1399: WHERE icg.item_creation_allowed_flag = 'Y' AND
1400: ((inactive_date is null) or ((trunc(inactive_date) > trunc(sysdate)) OR
1401: (icg.item_catalog_group_id=item_catalog_group_id))) AND
1402: icg.item_catalog_group_id = new_catalog_group_id

Line 1439: FROM mtl_item_catalog_groups_b

1435: RETURN BOOLEAN IS
1436:
1437: CURSOR c_get_npr_flag(cp_catalog_group_id NUMBER) IS
1438: SELECT new_item_request_reqd
1439: FROM mtl_item_catalog_groups_b
1440: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
1441: START WITH item_catalog_group_id = cp_catalog_group_id;
1442:
1443: l_npr_flag mtl_item_catalog_groups_b.new_item_request_reqd%TYPE;

Line 1443: l_npr_flag mtl_item_catalog_groups_b.new_item_request_reqd%TYPE;

1439: FROM mtl_item_catalog_groups_b
1440: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
1441: START WITH item_catalog_group_id = cp_catalog_group_id;
1442:
1443: l_npr_flag mtl_item_catalog_groups_b.new_item_request_reqd%TYPE;
1444: l_return_value BOOLEAN := FALSE;
1445: l_miss_num CONSTANT NUMBER := 9.99E125;
1446: BEGIN
1447: