APPS.INVPVDR5 dependencies on MTL_ITEM_CATALOG_GROUPS

Line 1123: from mtl_item_catalog_groups

1119: --2777118: Start Catalog Group check enhanced
1120: IF cr.transaction_type ='CREATE' THEN
1121: BEGIN
1122: select 'x' into temp
1123: from mtl_item_catalog_groups
1124: where item_catalog_group_id = cr.ITEM_CATALOG_GROUP_ID
1125: and item_creation_allowed_flag = 'Y'
1126: and NVL(inactive_date,sysdate+1) > sysdate;
1127: exception

Line 1161: FROM mtl_item_catalog_groups_b

1157: IF (NVL(l_old_catalog_id,-1) <> NVL(cr.item_catalog_group_id,-1) AND cr.item_catalog_group_id IS NOT NULL) THEN
1158: BEGIN
1159: /*Bug:3491746
1160: SELECT 'x' into temp
1161: FROM mtl_item_catalog_groups_b
1162: WHERE item_catalog_group_id = cr.item_catalog_group_id
1163: AND item_creation_allowed_flag = 'Y'
1164: AND item_catalog_group_id IN
1165: (SELECT ICG.item_catalog_group_id

Line 1166: FROM mtl_item_catalog_groups_b ICG

1162: WHERE item_catalog_group_id = cr.item_catalog_group_id
1163: AND item_creation_allowed_flag = 'Y'
1164: AND item_catalog_group_id IN
1165: (SELECT ICG.item_catalog_group_id
1166: FROM mtl_item_catalog_groups_b ICG
1167: WHERE ICG.item_creation_allowed_flag = 'Y'
1168: AND ((ICG.inactive_date IS NULL) OR (TRUNC(ICG.inactive_date) > TRUNC(SYSDATE))));
1169: ELSE
1170: SELECT 'x' into temp

Line 1171: FROM mtl_item_catalog_groups_b

1167: WHERE ICG.item_creation_allowed_flag = 'Y'
1168: AND ((ICG.inactive_date IS NULL) OR (TRUNC(ICG.inactive_date) > TRUNC(SYSDATE))));
1169: ELSE
1170: SELECT 'x' into temp
1171: FROM mtl_item_catalog_groups_b
1172: WHERE item_catalog_group_id = cr.item_catalog_group_id
1173: AND item_creation_allowed_flag = 'Y'
1174: AND item_catalog_group_id IN
1175: (SELECT ICG.item_catalog_group_id

Line 1176: FROM mtl_item_catalog_groups_b ICG

1172: WHERE item_catalog_group_id = cr.item_catalog_group_id
1173: AND item_creation_allowed_flag = 'Y'
1174: AND item_catalog_group_id IN
1175: (SELECT ICG.item_catalog_group_id
1176: FROM mtl_item_catalog_groups_b ICG
1177: WHERE ICG.item_creation_allowed_flag = 'Y'
1178: --Bug: 2805253 Removed NVL
1179: AND ((ICG.inactive_date IS NULL) OR (TRUNC(ICG.inactive_date) > TRUNC(SYSDATE)))
1180: CONNECT BY PRIOR ICG.item_catalog_group_id = ICG.parent_catalog_group_id

Line 1185: FROM mtl_item_catalog_groups_b

1181: START WITH ICG.item_catalog_group_id = l_old_catalog_id);
1182: END IF;
1183: */
1184: SELECT 'x' into temp
1185: FROM mtl_item_catalog_groups_b
1186: WHERE item_catalog_group_id = cr.item_catalog_group_id
1187: AND item_creation_allowed_flag = 'Y'
1188: AND (inactive_date IS NULL OR TRUNC(inactive_date) > TRUNC(SYSDATE));
1189: EXCEPTION