APPS.WSM_LBJ_INTERFACE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 5746: from mtl_material_transactions_temp mmtt

5742: and wro.inventory_item_id = l_item_old_id
5743: and wro.quantity_issued <> 0)
5744: or exists
5745: (select 1
5746: from mtl_material_transactions_temp mmtt
5747: where mmtt.transaction_source_id = p_wip_entity_id
5748: and mmtt.organization_id = p_org_id
5749: and mmtt.operation_seq_num = l_job_op_seq_num
5750: and mmtt.inventory_item_id = l_item_old_id);

Line 8920: from mtl_material_transactions_temp mmtt

8916:
8917: if l_temp_num <>0 then
8918: select 0
8919: into l_temp_num
8920: from mtl_material_transactions_temp mmtt
8921: where mmtt.organization_id = v_wsli(v_wlji_src_line_id(v_idx)).organization_id
8922: and mmtt.inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
8923: and nvl(mmtt.lot_number, '@#$') = v_wsli(v_wlji_src_line_id(v_idx)).lot_number
8924: and mmtt.subinventory_code = v_wsli(v_wlji_src_line_id(v_idx)).subinventory_code

Line 8932: from mtl_material_transactions_temp mmtt2

8928: and mmtt.transaction_source_type_id = 13 -- inventory
8929: and v_wsli(v_wlji_src_line_id(v_idx)).quantity = ((-1) * mmtt.transaction_quantity)
8930: and mmtt.transaction_date = (
8931: select max(mmtt2.transaction_date)
8932: from mtl_material_transactions_temp mmtt2
8933: where mmtt2.organization_id = v_wsli(v_wlji_src_line_id(v_idx)).organization_id
8934: and mmtt2.inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
8935: and nvl(mmtt2.lot_number, '@#$') = nvl(v_wsli(v_wlji_src_line_id(v_idx)).lot_number, '@#$')
8936: and mmtt2.subinventory_code = v_wsli(v_wlji_src_line_id(v_idx)).subinventory_code

Line 11626: insert into mtl_material_transactions_temp(

11622: end if;
11623:
11624: l_stmt_num := 1010;
11625: Begin -- material transaction
11626: insert into mtl_material_transactions_temp(
11627: last_update_date,
11628: creation_date,
11629: last_updated_by,
11630: created_by,

Line 20188: from mtl_material_transactions_temp mmtt,

20184: mmtt.error_code,
20185: mmtt.error_explanation,
20186: wsli.header_id,
20187: wlji.header_id
20188: from mtl_material_transactions_temp mmtt,
20189: wsm_starting_lots_interface wsli,
20190: wsm_lot_job_interface wlji
20191: where mmtt.transaction_header_id = p_header_id
20192: and mmtt.source_line_id = wsli.header_id

Line 20296: from mtl_material_transactions_temp

20292: where organization_id = p_organization_id
20293: and wip_entity_id = p_wip_entity_id)
20294: or exists (
20295: select 'x'
20296: from mtl_material_transactions_temp
20297: where organization_id = p_organization_id
20298: and transaction_source_type_id = 5
20299: and transaction_source_id = p_wip_entity_id)
20300: or exists (