APPS.INVIDIT3 dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 1589: FROM mtl_item_catalog_groups_b icg

1585: l_child_catalog := 'N';
1586: IF new_catalog_group_id IS NOT NULL THEN
1587: BEGIN
1588: SELECT 'Y' INTO L_child_catalog
1589: FROM mtl_item_catalog_groups_b icg
1590: WHERE icg.item_creation_allowed_flag = 'Y' AND
1591: ((inactive_date is null) or ((trunc(inactive_date) > trunc(sysdate)) OR
1592: (icg.item_catalog_group_id=item_catalog_group_id))) AND
1593: icg.item_catalog_group_id = new_catalog_group_id

Line 1630: FROM mtl_item_catalog_groups_b

1626: RETURN BOOLEAN IS
1627:
1628: CURSOR c_get_npr_flag(cp_catalog_group_id NUMBER) IS
1629: SELECT new_item_request_reqd
1630: FROM mtl_item_catalog_groups_b
1631: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
1632: START WITH item_catalog_group_id = cp_catalog_group_id;
1633:
1634: l_npr_flag mtl_item_catalog_groups_b.new_item_request_reqd%TYPE;

Line 1634: l_npr_flag mtl_item_catalog_groups_b.new_item_request_reqd%TYPE;

1630: FROM mtl_item_catalog_groups_b
1631: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
1632: START WITH item_catalog_group_id = cp_catalog_group_id;
1633:
1634: l_npr_flag mtl_item_catalog_groups_b.new_item_request_reqd%TYPE;
1635: l_return_value BOOLEAN := FALSE;
1636: l_miss_num CONSTANT NUMBER := 9.99E125;
1637: BEGIN
1638: