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 4793: FROM mtl_material_transactions_temp mmtt

4789: and rownum = 1;
4790:
4791: if l_dummy <>0 then
4792: SELECT 0 into l_dummy
4793: FROM mtl_material_transactions_temp mmtt
4794: WHERE mmtt.organization_id = v_wsli(v_wlji_source_line_id(v_index)).organization_id
4795: and mmtt.inventory_item_id = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
4796: and NVL(mmtt.lot_number, '@#$') = v_wsli(v_wlji_source_line_id(v_index)).lot_number
4797: and mmtt.subinventory_code = v_wsli(v_wlji_source_line_id(v_index)).subinventory_code

Line 4805: FROM mtl_material_transactions_temp mmtt2

4801: and mmtt.transaction_source_type_id = 13 -- Inventory
4802: and v_wsli(v_wlji_source_line_id(v_index)).quantity = ((-1) * mmtt.transaction_quantity)
4803: and mmtt.transaction_date = (
4804: SELECT max(mmtt2.transaction_date)
4805: FROM mtl_material_transactions_temp mmtt2
4806: WHERE mmtt2.organization_id = v_wsli(v_wlji_source_line_id(v_index)).organization_id
4807: and mmtt2.inventory_item_id = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
4808: and NVL(mmtt2.lot_number, '@#$') = NVL(v_wsli(v_wlji_source_line_id(v_index)).lot_number, '@#$')
4809: and mmtt2.subinventory_code = v_wsli(v_wlji_source_line_id(v_index)).subinventory_code

Line 7308: insert into mtl_material_transactions_temp(

7304:
7305: l_stmt_num := 1140;
7306: Begin -- material transaction
7307:
7308: insert into mtl_material_transactions_temp(
7309: last_update_date,
7310: creation_date,
7311: last_updated_by,
7312: created_by,