APPS.WSM_LBJ_INTERFACE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 5752: from mtl_material_transactions_temp mmtt

5748: and wro.inventory_item_id = l_item_old_id
5749: and wro.quantity_issued <> 0)
5750: or exists
5751: (select 1
5752: from mtl_material_transactions_temp mmtt
5753: where mmtt.transaction_source_id = p_wip_entity_id
5754: and mmtt.organization_id = p_org_id
5755: and mmtt.operation_seq_num = l_job_op_seq_num
5756: and mmtt.inventory_item_id = l_item_old_id);

Line 9018: from mtl_material_transactions_temp mmtt

9014:
9015: if l_temp_num <>0 then
9016: select 0
9017: into l_temp_num
9018: from mtl_material_transactions_temp mmtt
9019: where mmtt.organization_id = v_wsli(v_wlji_src_line_id(v_idx)).organization_id
9020: and mmtt.inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
9021: and nvl(mmtt.lot_number, '@#$') = v_wsli(v_wlji_src_line_id(v_idx)).lot_number
9022: and mmtt.subinventory_code = v_wsli(v_wlji_src_line_id(v_idx)).subinventory_code

Line 9030: from mtl_material_transactions_temp mmtt2

9026: and mmtt.transaction_source_type_id = 13 -- inventory
9027: and v_wsli(v_wlji_src_line_id(v_idx)).quantity = ((-1) * mmtt.transaction_quantity)
9028: and mmtt.transaction_date = (
9029: select max(mmtt2.transaction_date)
9030: from mtl_material_transactions_temp mmtt2
9031: where mmtt2.organization_id = v_wsli(v_wlji_src_line_id(v_idx)).organization_id
9032: and mmtt2.inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
9033: and nvl(mmtt2.lot_number, '@#$') = nvl(v_wsli(v_wlji_src_line_id(v_idx)).lot_number, '@#$')
9034: and mmtt2.subinventory_code = v_wsli(v_wlji_src_line_id(v_idx)).subinventory_code

Line 11730: insert into mtl_material_transactions_temp(

11726: end if;
11727:
11728: l_stmt_num := 1010;
11729: Begin -- material transaction
11730: insert into mtl_material_transactions_temp(
11731: last_update_date,
11732: creation_date,
11733: last_updated_by,
11734: created_by,

Line 20844: from mtl_material_transactions_temp mmtt,

20840: mmtt.error_code,
20841: mmtt.error_explanation,
20842: wsli.header_id,
20843: wlji.header_id
20844: from mtl_material_transactions_temp mmtt,
20845: wsm_starting_lots_interface wsli,
20846: wsm_lot_job_interface wlji
20847: where mmtt.transaction_header_id = p_header_id
20848: and mmtt.source_line_id = wsli.header_id

Line 20952: from mtl_material_transactions_temp

20948: where organization_id = p_organization_id
20949: and wip_entity_id = p_wip_entity_id)
20950: or exists (
20951: select 'x'
20952: from mtl_material_transactions_temp
20953: where organization_id = p_organization_id
20954: and transaction_source_type_id = 5
20955: and transaction_source_id = p_wip_entity_id)
20956: or exists (