APPS.CSTPUMEC dependencies on MTL_ITEM_CATEGORIES

Line 863: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc

859: WHERE msi1.concatenated_segments BETWEEN i_item_from AND i_item_to))
860: OR (i_range = 5
861: AND cic.inventory_item_id IN
862: (SELECT msi2.inventory_item_id
863: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc
864: WHERE mic.organization_id = i_org_id
865: AND mic.category_set_id = i_category_set
866: AND mic.inventory_item_id = msi2.inventory_item_id
867: AND mic.organization_id = msi2.organization_id

Line 914: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc

910: WHERE msi1.concatenated_segments BETWEEN i_item_from AND i_item_to))
911: OR (i_range = 5
912: AND cic.inventory_item_id IN
913: (SELECT msi2.inventory_item_id
914: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc
915: WHERE mic.organization_id = i_org_id
916: AND mic.category_set_id = i_category_set
917: AND mic.inventory_item_id = msi2.inventory_item_id
918: AND mic.organization_id = msi2.organization_id

Line 970: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc

966: WHERE msi1.concatenated_segments BETWEEN i_item_from AND i_item_to))
967: OR (i_range = 5
968: AND cic.inventory_item_id IN
969: (SELECT msi2.inventory_item_id
970: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc
971: WHERE mic.organization_id = i_org_id
972: AND mic.category_set_id = i_category_set
973: AND mic.inventory_item_id = msi2.inventory_item_id
974: AND mic.organization_id = msi2.organization_id

Line 1033: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc

1029: WHERE msi1.concatenated_segments BETWEEN i_item_from AND i_item_to))
1030: OR (i_range = 5
1031: AND cicd.inventory_item_id IN
1032: (SELECT msi2.inventory_item_id
1033: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc
1034: WHERE mic.organization_id = i_org_id
1035: AND mic.category_set_id = i_category_set
1036: AND mic.inventory_item_id = msi2.inventory_item_id
1037: AND mic.organization_id = msi2.organization_id

Line 1072: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc

1068: WHERE msi1.concatenated_segments BETWEEN i_item_from AND i_item_to))
1069: OR (i_range = 5
1070: AND cic.inventory_item_id IN
1071: (SELECT msi2.inventory_item_id
1072: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc
1073: WHERE mic.organization_id = i_org_id
1074: AND mic.category_set_id = i_category_set
1075: AND mic.inventory_item_id = msi2.inventory_item_id
1076: AND mic.organization_id = msi2.organization_id

Line 1163: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc

1159: WHERE msi1.concatenated_segments BETWEEN i_item_from AND i_item_to))
1160: OR (i_range = 5
1161: AND cic.inventory_item_id IN
1162: (SELECT msi2.inventory_item_id
1163: FROM mtl_system_items msi2, mtl_item_categories mic, mtl_categories_kfv mc
1164: WHERE mic.organization_id = i_org_id
1165: AND mic.category_set_id = i_category_set
1166: AND mic.inventory_item_id = msi2.inventory_item_id
1167: AND mic.organization_id = msi2.organization_id

Line 1284: AND cicd.inventory_item_id IN (SELECT mic.inventory_item_id FROM mtl_item_categories mic, mtl_categories_kfv mc

1280: SET cicd.rollup_source_type = 1
1281: WHERE cicd.rollup_source_type = 2
1282: AND cicd.cost_type_id = i_cost_type
1283: AND cicd.organization_id = i_org_id
1284: AND cicd.inventory_item_id IN (SELECT mic.inventory_item_id FROM mtl_item_categories mic, mtl_categories_kfv mc
1285: WHERE mic.organization_id = i_org_id
1286: AND mic.category_set_id = i_category_set
1287: AND mic.category_id = mc.category_id
1288: AND mc.concatenated_segments BETWEEN i_category_from AND i_category_to)