APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 30: FROM MTL_SYSTEM_ITEMS_B

26: l_Style_Item_Count NUMBER;
27: BEGIN
28: SELECT COUNT(1)
29: INTO l_Style_Item_Count
30: FROM MTL_SYSTEM_ITEMS_B
31: WHERE STYLE_ITEM_FLAG = 'Y'
32: AND ITEM_CATALOG_GROUP_ID IN
33: ( SELECT ITEM_CATALOG_GROUP_ID
34: FROM MTL_ITEM_CATALOG_GROUPS_B

Line 58: FROM MTL_SYSTEM_ITEMS_B

54: l_SKU_Item_Count NUMBER;
55: BEGIN
56: SELECT COUNT(1)
57: INTO l_SKU_Item_Count
58: FROM MTL_SYSTEM_ITEMS_B
59: WHERE STYLE_ITEM_FLAG = 'N'
60: AND ITEM_CATALOG_GROUP_ID IN
61: ( SELECT ITEM_CATALOG_GROUP_ID
62: FROM MTL_ITEM_CATALOG_GROUPS_B

Line 686: FROM MTL_SYSTEM_ITEMS_B

682:
683: IF l_existing_variants.COUNT > 0 THEN
684: SELECT COUNT(1)
685: INTO l_style_item_count
686: FROM MTL_SYSTEM_ITEMS_B
687: WHERE STYLE_ITEM_FLAG = 'Y'
688: AND ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id;
689: ELSE
690: l_style_item_count := 0;

Line 850: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp

846: l_org_code,
847: l_menu_disp_name,
848: l_ss_id,
849: -99
850: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
851: WHERE msib.STYLE_ITEM_ID = p_style_item_id
852: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
853: AND mp.ORGANIZATION_ID = p_organization_id
854: AND NOT EXISTS (SELECT NULL FROM FND_GRANTS fg

Line 911: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp

907: p_category_set_id,
908: p_category_id,
909: l_ss_id,
910: -99
911: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
912: WHERE msib.STYLE_ITEM_ID = p_style_item_id
913: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
914: AND mp.ORGANIZATION_ID = p_organization_id
915: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES mic