APPS.EGO_ITEM_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 592: ' FROM mtl_item_catalog_groups_b ic'||

588: ' AND MSI.LIFECYCLE_ID IS NOT NULL'||
589: ' AND (MSI.APPROVAL_STATUS IS NULL OR MSI.APPROVAL_STATUS =''A'') '||
590: ' AND ECP.POLICY_OBJECT_PK1_VALUE = '||
591: ' (SELECT TO_CHAR(ic.item_catalog_group_id) '||
592: ' FROM mtl_item_catalog_groups_b ic'||
593: ' WHERE EXISTS '||
594: ' ( SELECT olc.object_classification_code CatalogId '||
595: ' FROM ego_obj_type_lifecycles olc '||
596: ' WHERE olc.object_id = :3 '||

Line 731: FROM mtl_item_catalog_groups_b ic

727:
728: SELECT item_catalog_group_id
729: INTO l_policy_cat_id
730: FROM (SELECT item_catalog_group_id
731: FROM mtl_item_catalog_groups_b ic
732: WHERE EXISTS
733: ( SELECT olc.object_classification_code CatalogId
734: FROM ego_obj_type_lifecycles olc, mtl_system_items_b MSI
735: WHERE olc.object_id = l_object_id

Line 1537: FROM mtl_item_catalog_groups_b CONNECT BY prior parent_catalog_group_id = item_catalog_group_id

1533: AND AGV.OBJECT_NAME ='EGO_ITEM'
1534: AND AGV.CLASSIFICATION_CODE IS NOT NULL
1535: AND AGV.CLASSIFICATION_CODE IN
1536: (SELECT TO_CHAR(item_catalog_group_id)
1537: FROM mtl_item_catalog_groups_b CONNECT BY prior parent_catalog_group_id = item_catalog_group_id
1538: START WITH item_catalog_group_id = l_Item_rec_in.ITEM_CATALOG_GROUP_ID
1539: )
1540: UNION ALL
1541: SELECT ATTR_GROUP_ID

Line 1561: FROM mtl_item_catalog_groups_b CONNECT BY prior parent_catalog_group_id = item_catalog_group_id

1557: AND AGV.OBJECT_NAME ='EGO_ITEM'
1558: AND AGV.CLASSIFICATION_CODE IS NOT NULL
1559: AND AGV.CLASSIFICATION_CODE IN
1560: (SELECT TO_CHAR(item_catalog_group_id)
1561: FROM mtl_item_catalog_groups_b CONNECT BY prior parent_catalog_group_id = item_catalog_group_id
1562: START WITH item_catalog_group_id = l_Item_rec_in.ITEM_CATALOG_GROUP_ID
1563: )
1564: UNION ALL
1565: SELECT ATTR_GROUP_ID

Line 2228: FROM MTL_ITEM_CATALOG_GROUPS_B

2224: CURSOR parent_catalog_group_cursor
2225: IS
2226: SELECT ITEM_CATALOG_GROUP_ID
2227: ,PARENT_CATALOG_GROUP_ID
2228: FROM MTL_ITEM_CATALOG_GROUPS_B
2229: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
2230: START WITH ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
2231:
2232: BEGIN

Line 4135: FROM mtl_item_catalog_groups_b ic

4131: FROM MTL_ITEM_CATALOG_GROUPS_KFV
4132: WHERE ITEM_CATALOG_GROUP_ID = (
4133: SELECT item_catalog_group_id
4134: FROM (SELECT item_catalog_group_id
4135: FROM mtl_item_catalog_groups_b ic
4136: WHERE EXISTS
4137: ( SELECT olc.object_classification_code CatalogId
4138: FROM ego_obj_type_lifecycles olc, fnd_objects o
4139: WHERE o.obj_name = G_EGO_ITEM

Line 4605: ' FROM MTL_ITEM_CATALOG_GROUPS_B EgoNewItemReqSetupEO '||

4601: ' EgoNewItemReqSetupEO.ITEM_NUM_GEN_METHOD) ITEM_NUM_GEN_METHOD, '||
4602: ' EgoNewItemReqSetupEO.ITEM_NUM_SEQ_NAME, '||
4603: ' EgoNewItemReqSetupEO.PREFIX, '||
4604: ' EgoNewItemReqSetupEO.SUFFIX '||
4605: ' FROM MTL_ITEM_CATALOG_GROUPS_B EgoNewItemReqSetupEO '||
4606: ' CONNECT BY PRIOR EgoNewItemReqSetupEO.PARENT_CATALOG_GROUP_ID = '||
4607: ' EgoNewItemReqSetupEO.ITEM_CATALOG_GROUP_ID '||
4608: ' START WITH EgoNewItemReqSetupEO.ITEM_CATALOG_GROUP_ID = :ITEM_CATALOG_GROUP_ID ';
4609:

Line 4798: FROM MTL_ITEM_CATALOG_GROUPS_B

4794:
4795: -- if a default is not found, get the parent category ID
4796: SELECT PARENT_CATALOG_GROUP_ID
4797: INTO l_parent_id
4798: FROM MTL_ITEM_CATALOG_GROUPS_B
4799: WHERE ITEM_CATALOG_GROUP_ID = p_category_id;
4800:
4801: -- recurse on the parent category
4802: RETURN Get_Default_Template_Id(