APPS.CSI_WIP_TRXS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 213: FROM mtl_system_items

209: l_txn_ref.ib_trackable_flag,
210: l_txn_ref.bom_item_type,
211: l_txn_ref.item,
212: l_txn_ref.eam_item_type
213: FROM mtl_system_items
214: WHERE inventory_item_id = l_txn_ref.inventory_item_id
215: AND organization_id = l_txn_ref.organization_id;
216:
217: BEGIN

Line 1121: FROM wip_requirement_operations wip, mtl_system_items msi

1117: SELECT wip.inventory_item_id,
1118: sum(required_quantity) qty_required,
1119: sum(quantity_issued) qty_issued,
1120: nvl(sum(nvl(quantity_per_assembly,0)),0) qty_per_assy
1121: FROM wip_requirement_operations wip, mtl_system_items msi
1122: WHERE wip.wip_entity_id = p_wip_entity_id
1123: AND wip.organization_id = p_organization_id
1124: AND wip.inventory_item_id <> p_assembly_item_id
1125: AND wip.inventory_item_id = msi.inventory_item_id

Line 1143: FROM wip_requirement_operations wip, mtl_system_items msi

1139: SELECT wip.inventory_item_id,
1140: sum(required_quantity) qty_required,
1141: sum(quantity_issued) qty_issued,
1142: nvl(sum(nvl(quantity_per_assembly,0)),0) qty_per_assy
1143: FROM wip_requirement_operations wip, mtl_system_items msi
1144: WHERE wip.wip_entity_id = p_wip_entity_id
1145: AND wip.organization_id = p_organization_id
1146: AND wip.inventory_item_id <> p_assembly_item_id
1147: AND wip.inventory_item_id = msi.inventory_item_id

Line 2841: FROM mtl_system_items

2837: IF l_issued_instances.COUNT > 0 THEN
2838:
2839: SELECT serial_number_control_code
2840: INTO l_comp_serial_code
2841: FROM mtl_system_items
2842: WHERE inventory_item_id = l_requirements_tbl(l_ind).inventory_item_id
2843: AND organization_id = p_txn_ref.organization_id;
2844:
2845: -- only for non serial

Line 3469: FROM mtl_system_items

3465: SELECT serial_number_control_code ,
3466: segment1
3467: INTO l_comp_serial_code,
3468: l_comp_item
3469: FROM mtl_system_items
3470: WHERE inventory_item_id = issue_rec.inventory_item_id
3471: AND organization_id = p_organization_id;
3472:
3473: debug(' Component Item :'||l_comp_item||' - '||issue_rec.inventory_item_id);

Line 3739: FROM mtl_system_items msi,

3735: IS
3736:
3737: CURSOR mtl_txn_cur(p_migration_date IN date) IS
3738: SELECT transaction_id
3739: FROM mtl_system_items msi,
3740: mtl_material_transactions mmt
3741: WHERE mmt.transaction_source_type_id = 5 -- job/schedule transactions
3742: AND mmt.transaction_source_id = p_wip_entity_id
3743: AND mmt.transaction_action_id in (1, 27, 31, 32, 33, 34) -- ib handled wip actions

Line 4035: FROM mtl_system_items

4031: END IF;
4032:
4033: SELECT serial_number_control_code
4034: INTO l_assy_serial_code
4035: FROM mtl_system_items
4036: WHERE inventory_item_id = p_txn_ref.wip_assembly_item_id
4037: AND organization_id = p_txn_ref.organization_id;
4038:
4039: IF l_assy_serial_code in (1, 6) THEN -- non serial assembly

Line 6707: FROM mtl_system_items msi,

6703: x_return_status OUT nocopy varchar2)
6704: IS
6705: CURSOR mtl_txn_cur(p_wip_entity_id IN number, p_migration_date IN date) IS
6706: SELECT transaction_id
6707: FROM mtl_system_items msi,
6708: mtl_material_transactions mmt
6709: WHERE mmt.transaction_source_type_id = 5 -- job/schedule transactions
6710: AND mmt.transaction_source_id = p_wip_entity_id
6711: AND mmt.transaction_action_id in (1, 27, 31, 32, 33, 34) -- ib handled wip actions