APPS.CSTPUMEC dependencies on MTL_SYSTEM_ITEMS_KFV

Line 799: l_itemname mtl_system_items_kfv.concatenated_segments%TYPE;

795: -- The next three variables are used to print a warning message with the
796: -- fnd_message utilities.
797: l_orgcode mtl_parameters.organization_code%TYPE := NULL;
798: l_costtype cst_cost_types.cost_type%TYPE := NULL;
799: l_itemname mtl_system_items_kfv.concatenated_segments%TYPE;
800:
801: BEGIN
802:
803: -- Start of program SAVEPOINT

Line 858: FROM mtl_system_items_kfv msi1

854: AND cic.inventory_item_id = i_specific_item)
855: OR (i_range = 3
856: AND cic.inventory_item_id IN
857: (SELECT msi1.inventory_item_id
858: FROM mtl_system_items_kfv msi1
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

Line 909: FROM mtl_system_items_kfv msi1

905: AND cic.inventory_item_id = i_specific_item)
906: OR (i_range = 3
907: AND cic.inventory_item_id IN
908: (SELECT msi1.inventory_item_id
909: FROM mtl_system_items_kfv msi1
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

Line 965: FROM mtl_system_items_kfv msi1

961: AND cic.inventory_item_id = i_specific_item)
962: OR (i_range = 3
963: AND cic.inventory_item_id IN
964: (SELECT msi1.inventory_item_id
965: FROM mtl_system_items_kfv msi1
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

Line 1028: FROM mtl_system_items_kfv msi1

1024: AND cicd.inventory_item_id = i_specific_item)
1025: OR (i_range = 3
1026: AND cicd.inventory_item_id IN
1027: (SELECT msi1.inventory_item_id
1028: FROM mtl_system_items_kfv msi1
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

Line 1067: FROM mtl_system_items_kfv msi1

1063: AND cic.inventory_item_id = i_specific_item)
1064: OR (i_range = 3
1065: AND cic.inventory_item_id IN
1066: (SELECT msi1.inventory_item_id
1067: FROM mtl_system_items_kfv msi1
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

Line 1107: from mtl_system_items_kfv

1103:
1104: FOR i in 1..l_nonzero_shrinkage LOOP
1105: select concatenated_segments
1106: into l_itemname
1107: from mtl_system_items_kfv
1108: where organization_id = i_org_id
1109: and inventory_item_id = l_items(i);
1110: fnd_file.put_line(fnd_file.log, l_itemname);
1111: END LOOP;

Line 1158: FROM mtl_system_items_kfv msi1

1154: AND cic.inventory_item_id = i_specific_item)
1155: OR (i_range = 3
1156: AND cic.inventory_item_id IN
1157: (SELECT msi1.inventory_item_id
1158: FROM mtl_system_items_kfv msi1
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

Line 1211: from mtl_system_items_kfv

1207:
1208: FOR i in 1..l_items.COUNT LOOP
1209: select concatenated_segments
1210: into l_itemname
1211: from mtl_system_items_kfv
1212: where organization_id = i_org_id
1213: and inventory_item_id = l_items(i);
1214: fnd_file.put_line(fnd_file.log, l_itemname);
1215: END LOOP;

Line 1267: AND cicd.inventory_item_id IN (SELECT msi1.inventory_item_id FROM mtl_system_items_kfv msi1 WHERE msi1.concatenated_segments BETWEEN i_item_from AND i_item_to)

1263: SET cicd.rollup_source_type = 1
1264: WHERE cicd.rollup_source_type = 2
1265: AND cicd.cost_type_id = i_cost_type
1266: AND cicd.organization_id = i_org_id
1267: AND cicd.inventory_item_id IN (SELECT msi1.inventory_item_id FROM mtl_system_items_kfv msi1 WHERE msi1.concatenated_segments BETWEEN i_item_from AND i_item_to)
1268: AND EXISTS (SELECT 'X'
1269: FROM cst_item_costs cic
1270: WHERE cic.organization_id = cicd.organization_id
1271: AND cic.cost_type_id = cicd.cost_type_id