APPS.WSMPLBJI dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1591: from mtl_material_transactions_temp mmtt,

1587: mmtt.error_code,
1588: mmtt.error_explanation,
1589: wsli.header_id,
1590: wlji.header_id
1591: from mtl_material_transactions_temp mmtt,
1592: wsm_starting_lots_interface wsli,
1593: wsm_lot_job_interface wlji
1594: where mmtt.transaction_header_id = p_header_id
1595: and mmtt.source_line_id = wsli.header_id

Line 2156: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

2152: FROM WIP_COST_TXN_INTERFACE
2153: WHERE ORGANIZATION_ID = p_organization_id
2154: AND WIP_ENTITY_ID = p_wip_entity_id)
2155: OR EXISTS (SELECT 'X'
2156: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
2157: WHERE ORGANIZATION_ID = p_organization_id
2158: AND TRANSACTION_SOURCE_TYPE_ID = 5
2159: AND TRANSACTION_SOURCE_ID = p_wip_entity_id)
2160: OR EXISTS (SELECT 'X'

Line 4799: FROM mtl_material_transactions_temp mmtt

4795: and rownum = 1;
4796:
4797: if l_dummy <>0 then
4798: SELECT 0 into l_dummy
4799: FROM mtl_material_transactions_temp mmtt
4800: WHERE mmtt.organization_id = v_wsli(v_wlji_source_line_id(v_index)).organization_id
4801: and mmtt.inventory_item_id = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
4802: and NVL(mmtt.lot_number, '@#$') = v_wsli(v_wlji_source_line_id(v_index)).lot_number
4803: and mmtt.subinventory_code = v_wsli(v_wlji_source_line_id(v_index)).subinventory_code

Line 4811: FROM mtl_material_transactions_temp mmtt2

4807: and mmtt.transaction_source_type_id = 13 -- Inventory
4808: and v_wsli(v_wlji_source_line_id(v_index)).quantity = ((-1) * mmtt.transaction_quantity)
4809: and mmtt.transaction_date = (
4810: SELECT max(mmtt2.transaction_date)
4811: FROM mtl_material_transactions_temp mmtt2
4812: WHERE mmtt2.organization_id = v_wsli(v_wlji_source_line_id(v_index)).organization_id
4813: and mmtt2.inventory_item_id = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
4814: and NVL(mmtt2.lot_number, '@#$') = NVL(v_wsli(v_wlji_source_line_id(v_index)).lot_number, '@#$')
4815: and mmtt2.subinventory_code = v_wsli(v_wlji_source_line_id(v_index)).subinventory_code

Line 7314: insert into mtl_material_transactions_temp(

7310:
7311: l_stmt_num := 1140;
7312: Begin -- material transaction
7313:
7314: insert into mtl_material_transactions_temp(
7315: last_update_date,
7316: creation_date,
7317: last_updated_by,
7318: created_by,