APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 13: FROM mtl_system_items_b

9: CURSOR Is_STYLE_SKU_EXIST(l_catalog_group_id NUMBER,
10: l_flag VARCHAR2)
11: IS
12: SELECT 1
13: FROM mtl_system_items_b
14: WHERE rownum = 1 AND
15: style_item_flag = l_flag AND
16: item_catalog_group_id IN
17: (SELECT item_catalog_group_id

Line 47: FROM MTL_SYSTEM_ITEMS_B

43: BEGIN
44:
45: /* SELECT COUNT(1)
46: INTO l_Style_Item_Count
47: FROM MTL_SYSTEM_ITEMS_B
48: WHERE STYLE_ITEM_FLAG = 'Y'
49: AND ITEM_CATALOG_GROUP_ID IN
50: ( SELECT ITEM_CATALOG_GROUP_ID
51: FROM MTL_ITEM_CATALOG_GROUPS_B

Line 89: FROM MTL_SYSTEM_ITEMS_B

85: BEGIN
86:
87: /*SELECT COUNT(1)
88: INTO l_SKU_Item_Count
89: FROM MTL_SYSTEM_ITEMS_B
90: WHERE STYLE_ITEM_FLAG = 'N'
91: AND ITEM_CATALOG_GROUP_ID IN
92: ( SELECT ITEM_CATALOG_GROUP_ID
93: FROM MTL_ITEM_CATALOG_GROUPS_B

Line 735: FROM MTL_SYSTEM_ITEMS_B

731: );
732:
733: CURSOR IS_ICC_EXIST_FOR_STYLE(l_catalog_group_id NUMBER, l_flag VARCHAR2) IS
734: SELECT 1
735: FROM MTL_SYSTEM_ITEMS_B
736: WHERE ROWNUM=1
737: AND STYLE_ITEM_FLAG = l_flag
738: AND ITEM_CATALOG_GROUP_ID = l_catalog_group_id;
739:

Line 759: FROM MTL_SYSTEM_ITEMS_B

755:
756: IF l_existing_variants.COUNT > 0 THEN
757: /*SELECT COUNT(1)
758: INTO l_style_item_count
759: FROM MTL_SYSTEM_ITEMS_B
760: WHERE STYLE_ITEM_FLAG = 'Y'
761: AND ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id; */
762:
763: OPEN Is_Icc_Exist_For_Style(p_item_catalog_group_id, 'Y');

Line 938: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp

934: l_org_code,
935: l_menu_disp_name,
936: l_ss_id,
937: -99
938: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
939: WHERE msib.STYLE_ITEM_ID = p_style_item_id
940: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
941: AND mp.ORGANIZATION_ID = p_organization_id
942: AND NOT EXISTS (SELECT NULL FROM FND_GRANTS fg

Line 999: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp

995: p_category_set_id,
996: p_category_id,
997: l_ss_id,
998: -99
999: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
1000: WHERE msib.STYLE_ITEM_ID = p_style_item_id
1001: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
1002: AND mp.ORGANIZATION_ID = p_organization_id
1003: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES mic