APPS.INVPVDR5 dependencies on MTL_ITEM_CATALOG_GROUPS

Line 1152: from mtl_item_catalog_groups

1148: --2777118: Start Catalog Group check enhanced
1149: IF cr.transaction_type ='CREATE' THEN
1150: BEGIN
1151: select 'x' into temp
1152: from mtl_item_catalog_groups
1153: where item_catalog_group_id = cr.ITEM_CATALOG_GROUP_ID
1154: and item_creation_allowed_flag = 'Y'
1155: and NVL(inactive_date,sysdate+1) > sysdate;
1156: exception

Line 1190: FROM mtl_item_catalog_groups_b

1186: IF (NVL(l_old_catalog_id,-1) <> NVL(cr.item_catalog_group_id,-1) AND cr.item_catalog_group_id IS NOT NULL) THEN
1187: BEGIN
1188: /*Bug:3491746
1189: SELECT 'x' into temp
1190: FROM mtl_item_catalog_groups_b
1191: WHERE item_catalog_group_id = cr.item_catalog_group_id
1192: AND item_creation_allowed_flag = 'Y'
1193: AND item_catalog_group_id IN
1194: (SELECT ICG.item_catalog_group_id

Line 1195: FROM mtl_item_catalog_groups_b ICG

1191: WHERE item_catalog_group_id = cr.item_catalog_group_id
1192: AND item_creation_allowed_flag = 'Y'
1193: AND item_catalog_group_id IN
1194: (SELECT ICG.item_catalog_group_id
1195: FROM mtl_item_catalog_groups_b ICG
1196: WHERE ICG.item_creation_allowed_flag = 'Y'
1197: AND ((ICG.inactive_date IS NULL) OR (TRUNC(ICG.inactive_date) > TRUNC(SYSDATE))));
1198: ELSE
1199: SELECT 'x' into temp

Line 1200: FROM mtl_item_catalog_groups_b

1196: WHERE ICG.item_creation_allowed_flag = 'Y'
1197: AND ((ICG.inactive_date IS NULL) OR (TRUNC(ICG.inactive_date) > TRUNC(SYSDATE))));
1198: ELSE
1199: SELECT 'x' into temp
1200: FROM mtl_item_catalog_groups_b
1201: WHERE item_catalog_group_id = cr.item_catalog_group_id
1202: AND item_creation_allowed_flag = 'Y'
1203: AND item_catalog_group_id IN
1204: (SELECT ICG.item_catalog_group_id

Line 1205: FROM mtl_item_catalog_groups_b ICG

1201: WHERE item_catalog_group_id = cr.item_catalog_group_id
1202: AND item_creation_allowed_flag = 'Y'
1203: AND item_catalog_group_id IN
1204: (SELECT ICG.item_catalog_group_id
1205: FROM mtl_item_catalog_groups_b ICG
1206: WHERE ICG.item_creation_allowed_flag = 'Y'
1207: --Bug: 2805253 Removed NVL
1208: AND ((ICG.inactive_date IS NULL) OR (TRUNC(ICG.inactive_date) > TRUNC(SYSDATE)))
1209: CONNECT BY PRIOR ICG.item_catalog_group_id = ICG.parent_catalog_group_id

Line 1214: FROM mtl_item_catalog_groups_b

1210: START WITH ICG.item_catalog_group_id = l_old_catalog_id);
1211: END IF;
1212: */
1213: SELECT 'x' into temp
1214: FROM mtl_item_catalog_groups_b
1215: WHERE item_catalog_group_id = cr.item_catalog_group_id
1216: AND item_creation_allowed_flag = 'Y'
1217: AND (inactive_date IS NULL OR TRUNC(inactive_date) > TRUNC(SYSDATE));
1218: EXCEPTION