APPS.EGO_ODI_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 6144: FROM MTL_ITEM_CATALOG_GROUPS_B

6140: SELECT ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID,lev FROM
6141: ( SELECT iccb.ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID ,lev
6142: FROM EGO_MTL_CATALOG_GRP_VERS_B iccb,
6143: ( SELECT ITEM_CATALOG_GROUP_ID,LEVEL lev
6144: FROM MTL_ITEM_CATALOG_GROUPS_B
6145: START WITH ITEM_CATALOG_GROUP_ID =cp_icc_id
6146: CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID=PARENT_CATALOG_GROUP_ID
6147: ) hier
6148: WHERE iccb.item_catalog_group_id=hier.item_catalog_group_id

Line 6190: FROM MTL_ITEM_CATALOG_GROUPS_B

6186: SELECT ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID,lev FROM
6187: ( SELECT iccb.ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID ,lev
6188: FROM EGO_MTL_CATALOG_GRP_VERS_B iccb,
6189: ( SELECT ITEM_CATALOG_GROUP_ID,LEVEL lev
6190: FROM MTL_ITEM_CATALOG_GROUPS_B
6191: START WITH ITEM_CATALOG_GROUP_ID =cp_icc_id
6192: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID=ITEM_CATALOG_GROUP_ID
6193: ) hier
6194: WHERE iccb.item_catalog_group_id=hier.item_catalog_group_id

Line 6241: FROM MTL_ITEM_CATALOG_GROUPS_B

6237: -- Non versioned ICC
6238: UNION
6239: SELECT ITEM_CATALOG_GROUP_ID,NULL AS version_seq_id, lev FROM
6240: ( SELECT ITEM_CATALOG_GROUP_ID,LEVEL lev
6241: FROM MTL_ITEM_CATALOG_GROUPS_B
6242: START WITH ITEM_CATALOG_GROUP_ID =cp_icc_id
6243: CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID=PARENT_CATALOG_GROUP_ID
6244: )
6245: WHERE

Line 6255: FROM MTL_ITEM_CATALOG_GROUPS_B

6251: -- Non versioned ICC
6252: UNION
6253: SELECT ITEM_CATALOG_GROUP_ID,NULL AS version_seq_id, lev FROM
6254: ( SELECT ITEM_CATALOG_GROUP_ID,LEVEL lev
6255: FROM MTL_ITEM_CATALOG_GROUPS_B
6256: START WITH ITEM_CATALOG_GROUP_ID =cp_icc_id
6257: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID=ITEM_CATALOG_GROUP_ID
6258: )
6259: WHERE

Line 7171: FROM mtl_item_catalog_groups_b base ,EGO_MTL_CATALOG_GRP_VERS_B vers

7167: CURSOR cur_ver_icc(cp_item_catalog_group_id NUMBER,
7168: cp_version_seq_id NUMBER)
7169: IS
7170: SELECT Count(base.item_catalog_group_id) ver_icc_count
7171: FROM mtl_item_catalog_groups_b base ,EGO_MTL_CATALOG_GRP_VERS_B vers
7172: WHERE base.item_catalog_group_id= vers.item_catalog_group_id
7173: AND base.item_catalog_group_id=cp_item_catalog_group_id
7174: AND vers.version_seq_id=Nvl(cp_version_seq_id,vers.version_seq_id)
7175: AND vers.version_seq_id>0; --Yjain

Line 7182: FROM mtl_item_catalog_groups_b

7178: --Cursor for non versioned ICC
7179: CURSOR cur_icc(cp_item_catalog_group_id NUMBER)
7180: IS
7181: SELECT Count(item_catalog_group_id) icc_count
7182: FROM mtl_item_catalog_groups_b
7183: WHERE item_catalog_group_id=cp_item_catalog_group_id;
7184:
7185:
7186:

Line 7420: FROM mtl_item_catalog_groups_b

7416: mtl_item_catalog_groups_kfv icv ,
7417: (
7418: SELECT item_catalog_group_id,
7419: LEVEL lev
7420: FROM mtl_item_catalog_groups_b
7421: START WITH item_catalog_group_id = cp_item_catalog_category_id
7422: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
7423: )
7424: hier