DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 596: ' FROM mtl_item_catalog_groups_b ic'||

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

Line 735: FROM mtl_item_catalog_groups_b ic

731:
732: SELECT item_catalog_group_id
733: INTO l_policy_cat_id
734: FROM (SELECT item_catalog_group_id
735: FROM mtl_item_catalog_groups_b ic
736: WHERE EXISTS
737: ( SELECT olc.object_classification_code CatalogId
738: FROM ego_obj_type_lifecycles olc, mtl_system_items_b MSI
739: WHERE olc.object_id = l_object_id

Line 874: FROM mtl_item_catalog_groups_b CONNECT BY prior parent_catalog_group_id = item_catalog_group_id

870: AND AGV.OBJECT_NAME ='EGO_ITEM'
871: AND AGV.CLASSIFICATION_CODE IS NOT NULL
872: AND AGV.CLASSIFICATION_CODE IN
873: (SELECT TO_CHAR(item_catalog_group_id)
874: FROM mtl_item_catalog_groups_b CONNECT BY prior parent_catalog_group_id = item_catalog_group_id
875: START WITH item_catalog_group_id = p_new_icc_id
876: )
877: UNION ALL
878: SELECT ATTR_GROUP_ID

Line 900: FROM mtl_item_catalog_groups_b CONNECT BY prior parent_catalog_group_id = item_catalog_group_id

896: AND AGV.OBJECT_NAME ='EGO_ITEM'
897: AND AGV.CLASSIFICATION_CODE IS NOT NULL
898: AND AGV.CLASSIFICATION_CODE IN
899: (SELECT TO_CHAR(item_catalog_group_id)
900: FROM mtl_item_catalog_groups_b CONNECT BY prior parent_catalog_group_id = item_catalog_group_id
901: START WITH item_catalog_group_id = p_new_icc_id
902: )
903: UNION ALL
904: SELECT ATTR_GROUP_ID

Line 2454: FROM MTL_ITEM_CATALOG_GROUPS_B

2450: CURSOR parent_catalog_group_cursor
2451: IS
2452: SELECT ITEM_CATALOG_GROUP_ID
2453: ,PARENT_CATALOG_GROUP_ID
2454: FROM MTL_ITEM_CATALOG_GROUPS_B
2455: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
2456: START WITH ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
2457:
2458: BEGIN

Line 4596: FROM mtl_item_catalog_groups_b ic

4592: FROM MTL_ITEM_CATALOG_GROUPS_KFV
4593: WHERE ITEM_CATALOG_GROUP_ID = (
4594: SELECT item_catalog_group_id
4595: FROM (SELECT item_catalog_group_id
4596: FROM mtl_item_catalog_groups_b ic
4597: WHERE EXISTS
4598: ( SELECT olc.object_classification_code CatalogId
4599: FROM ego_obj_type_lifecycles olc, fnd_objects o
4600: WHERE o.obj_name = G_EGO_ITEM

Line 5096: ' FROM MTL_ITEM_CATALOG_GROUPS_B EgoNewItemReqSetupEO '||

5092: ' EgoNewItemReqSetupEO.ITEM_NUM_GEN_METHOD) ITEM_NUM_GEN_METHOD, '||
5093: ' EgoNewItemReqSetupEO.ITEM_NUM_SEQ_NAME, '||
5094: ' EgoNewItemReqSetupEO.PREFIX, '||
5095: ' EgoNewItemReqSetupEO.SUFFIX '||
5096: ' FROM MTL_ITEM_CATALOG_GROUPS_B EgoNewItemReqSetupEO '||
5097: ' CONNECT BY PRIOR EgoNewItemReqSetupEO.PARENT_CATALOG_GROUP_ID = '||
5098: ' EgoNewItemReqSetupEO.ITEM_CATALOG_GROUP_ID '||
5099: ' START WITH EgoNewItemReqSetupEO.ITEM_CATALOG_GROUP_ID = :ITEM_CATALOG_GROUP_ID ';
5100:

Line 5294: FROM MTL_ITEM_CATALOG_GROUPS_B

5290:
5291: -- if a default is not found, get the parent category ID
5292: SELECT PARENT_CATALOG_GROUP_ID
5293: INTO l_parent_id
5294: FROM MTL_ITEM_CATALOG_GROUPS_B
5295: WHERE ITEM_CATALOG_GROUP_ID = p_category_id;
5296:
5297: -- recurse on the parent category
5298: RETURN Get_Default_Template_Id(