APPS.EGO_PUB_WS_ICC dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 156: instead of mtl_item_catalog_groups_b_kfv */

152: END IF;
153:
154: /* icc_id is given most priority. If it is given, then we derive the icc_name
155: Since catalog_group_name is not translatable, mtl_item_catalog_groups_v can also be used
156: instead of mtl_item_catalog_groups_b_kfv */
157:
158: IF (p_icc_id IS NOT NULL) THEN
159:
160: BEGIN

Line 915: FROM mtl_item_catalog_groups_b

911: cat.catalog_concat_segs
912: FROM mtl_item_catalog_groups_v cat,
913: (SELECT item_catalog_group_id,
914: LEVEL lev
915: FROM mtl_item_catalog_groups_b
916: START WITH item_catalog_group_id = p_item_catalog_group_id
917: CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id
918: ) hier,
919: ego_mtl_catalog_grp_vers_b iccb

Line 936: FROM mtl_item_catalog_groups_b

932: cat.catalog_concat_segs
933: FROM mtl_item_catalog_groups_v cat,
934: (SELECT item_catalog_group_id,
935: LEVEL lev
936: FROM mtl_item_catalog_groups_b
937: START WITH item_catalog_group_id = p_item_catalog_group_id
938: CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id
939: ) hier
940: WHERE cat.item_catalog_group_id = hier.item_catalog_group_id

Line 992: FROM mtl_item_catalog_groups_b

988: cat.catalog_concat_segs
989: FROM mtl_item_catalog_groups_v cat,
990: (SELECT item_catalog_group_id,
991: LEVEL lev
992: FROM mtl_item_catalog_groups_b
993: START WITH item_catalog_group_id = p_item_catalog_group_id
994: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
995: ) hier,
996: ego_mtl_catalog_grp_vers_b iccb

Line 1013: FROM mtl_item_catalog_groups_b

1009: cat.catalog_concat_segs
1010: FROM mtl_item_catalog_groups_v cat,
1011: (SELECT item_catalog_group_id,
1012: LEVEL lev
1013: FROM mtl_item_catalog_groups_b
1014: START WITH item_catalog_group_id = p_item_catalog_group_id
1015: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
1016: ) hier
1017: WHERE cat.item_catalog_group_id = hier.item_catalog_group_id