APPS.CSI_WIP_TRXS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 215: FROM mtl_system_items

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

Line 801: mtl_system_items_b msib

797: --Changed for Bug 12636010
798: SELECT msn.serial_number child_serial_number
799: FROM mtl_object_genealogy mog,
800: mtl_serial_numbers msn,
801: mtl_system_items_b msib
802: WHERE mog.parent_object_type = 2
803: AND msib.inventory_item_id = msn.inventory_item_id
804: AND msib.organization_id = msn.current_organization_id
805: AND nvl(msib.comms_nl_trackable_flag, 'N') = 'Y'

Line 1141: FROM wip_requirement_operations wip, mtl_system_items msi

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

Line 1163: FROM wip_requirement_operations wip, mtl_system_items msi

1159: SELECT wip.inventory_item_id,
1160: sum(required_quantity) qty_required,
1161: sum(quantity_issued) qty_issued,
1162: nvl(sum(nvl(quantity_per_assembly,0)),0) qty_per_assy
1163: FROM wip_requirement_operations wip, mtl_system_items msi
1164: WHERE wip.wip_entity_id = p_wip_entity_id
1165: AND wip.organization_id = p_organization_id
1166: AND wip.inventory_item_id <> p_assembly_item_id
1167: AND wip.inventory_item_id = msi.inventory_item_id

Line 2174: mtl_system_items_b msib

2170: SELECT msn.serial_number child_serial_number,
2171: msn.inventory_item_id child_item_id
2172: FROM mtl_object_genealogy mog,
2173: mtl_serial_numbers msn,
2174: mtl_system_items_b msib
2175: WHERE mog.parent_object_type = 2
2176: AND msib.inventory_item_id = msn.inventory_item_id
2177: AND msib.organization_id = msn.current_organization_id
2178: AND nvl(msib.comms_nl_trackable_flag, 'N') = 'Y'

Line 2301: mtl_system_items_b msib

2297: INTO l_parent_serial_number,
2298: l_parent_item_id
2299: FROM mtl_object_genealogy mog,
2300: mtl_serial_numbers msn,
2301: mtl_system_items_b msib
2302: WHERE mog.object_type = 2 -- serial genealogy
2303: AND msib.inventory_item_id = msn.inventory_item_id
2304: AND msib.organization_id = msn.current_organization_id
2305: AND nvl(msib.comms_nl_trackable_flag, 'N') = 'Y'

Line 2907: FROM mtl_system_items

2903: IF l_issued_instances.COUNT > 0 THEN
2904:
2905: SELECT serial_number_control_code
2906: INTO l_comp_serial_code
2907: FROM mtl_system_items
2908: WHERE inventory_item_id = l_requirements_tbl(l_ind).inventory_item_id
2909: AND organization_id = p_txn_ref.organization_id;
2910:
2911: -- Get serial tagging control 9977630

Line 3598: FROM mtl_system_items

3594: SELECT serial_number_control_code ,
3595: segment1
3596: INTO l_comp_serial_code,
3597: l_comp_item
3598: FROM mtl_system_items
3599: WHERE inventory_item_id = issue_rec.inventory_item_id
3600: AND organization_id = p_organization_id;
3601:
3602: debug(' Component Item :'||l_comp_item||' - '||issue_rec.inventory_item_id);

Line 3868: FROM mtl_system_items msi,

3864: IS
3865:
3866: CURSOR mtl_txn_cur(p_migration_date IN date) IS
3867: SELECT transaction_id
3868: FROM mtl_system_items msi,
3869: mtl_material_transactions mmt
3870: WHERE mmt.transaction_source_type_id = 5 -- job/schedule transactions
3871: AND mmt.transaction_source_id = p_wip_entity_id
3872: AND mmt.transaction_action_id in (1, 27, 31, 32, 33, 34) -- ib handled wip actions

Line 4170: FROM mtl_system_items

4166: END IF;
4167:
4168: SELECT serial_number_control_code
4169: INTO l_assy_serial_code
4170: FROM mtl_system_items
4171: WHERE inventory_item_id = p_txn_ref.wip_assembly_item_id
4172: AND organization_id = p_txn_ref.organization_id;
4173:
4174: IF l_assy_serial_code in (1, 6) THEN -- non serial assembly

Line 6913: FROM mtl_system_items msi,

6909: x_return_status OUT nocopy varchar2)
6910: IS
6911: CURSOR mtl_txn_cur(p_wip_entity_id IN number, p_migration_date IN date) IS
6912: SELECT transaction_id
6913: FROM mtl_system_items msi,
6914: mtl_material_transactions mmt
6915: WHERE mmt.transaction_source_type_id = 5 -- job/schedule transactions
6916: AND mmt.transaction_source_id = p_wip_entity_id
6917: AND mmt.transaction_action_id in (1, 27, 31, 32, 33, 34) -- ib handled wip actions