APPS.EGO_PUB_WS_ICC dependencies on MTL_ITEM_CATALOG_GROUPS_V

Line 24: catalog_concat_segs mtl_item_catalog_groups_v.catalog_concat_segs%TYPE

20: --
21: TYPE t_icc_id_rec IS RECORD (
22: item_catalog_group_id ego_mtl_catalog_grp_vers_b.item_catalog_group_id%TYPE,
23: version_seq_id ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE,
24: catalog_concat_segs mtl_item_catalog_groups_v.catalog_concat_segs%TYPE
25: );
26:
27: TYPE t_icc_id_recs IS TABLE OF t_icc_id_rec INDEX BY BINARY_INTEGER;
28:

Line 155: Since catalog_group_name is not translatable, mtl_item_catalog_groups_v can also be used

151: RETURN FALSE;
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:

Line 163: FROM mtl_item_catalog_groups_v

159:
160: BEGIN
161: SELECT catalog_concat_segs
162: INTO p_icc_name
163: FROM mtl_item_catalog_groups_v
164: WHERE item_catalog_group_id = To_Number(p_icc_id);
165: /* kkq - do we have to check for inactive_date in the above query */
166: --debug(L_PROC_NAME||' p_icc_id: '||p_icc_id||' ,p_icc_name: '||p_icc_name);
167:

Line 196: FROM mtl_item_catalog_groups_v

192: IF (p_icc_name IS NOT NULL AND p_icc_id IS NULL) THEN
193: BEGIN
194: SELECT To_Char(item_catalog_group_id)
195: INTO p_icc_id
196: FROM mtl_item_catalog_groups_v
197: WHERE catalog_concat_segs = p_icc_name;
198: /* kkq - do we have to check for inactive_date in the above query */
199: --debug(L_PROC_NAME||' p_icc_id: '||p_icc_id||' ,p_icc_name: '||p_icc_name);
200:

Line 912: FROM mtl_item_catalog_groups_v cat,

908: IS
909: SELECT hier.item_catalog_group_id,
910: iccb.version_seq_id,
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

Line 933: FROM mtl_item_catalog_groups_v cat,

929: IS
930: SELECT hier.item_catalog_group_id,
931: null version_seq_id,
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

Line 989: FROM mtl_item_catalog_groups_v cat,

985: IS
986: SELECT hier.item_catalog_group_id,
987: iccb.version_seq_id,
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

Line 1010: FROM mtl_item_catalog_groups_v cat,

1006: IS
1007: SELECT hier.item_catalog_group_id,
1008: null version_seq_id,
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