APPS.WSMPLBJI dependencies on MTL_MATERIAL_TRANSACTIONS

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 2176: FROM MTL_MATERIAL_TRANSACTIONS

2172: AND WIP_ENTITY_ID = p_wip_entity_id
2173: AND APPLIED_RESOURCE_UNITS <> 0)
2174: /* for bug fix 16327585 */
2175: OR EXISTS (SELECT 'X'
2176: FROM MTL_MATERIAL_TRANSACTIONS
2177: WHERE ORGANIZATION_ID = p_organization_id
2178: AND TRANSACTION_SOURCE_TYPE_ID = 5
2179: AND TRANSACTION_SOURCE_ID = p_wip_entity_id
2180: AND COSTED_FLAG IN ('N', 'E')));

Line 3248: select mtl_material_transactions_s.nextval

3244: -- ==============================================================================================
3245: -- getting the header_id to be populated for mmtt
3246: -- ==============================================================================================
3247:
3248: select mtl_material_transactions_s.nextval
3249: into txn_header_id
3250: from dual;
3251:
3252: -- ==============================================================================================

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 7306: select mtl_material_transactions_s.nextval

7302: end if;
7303:
7304: l_stmt_num := 1120;
7305: /* commented out by BBK for DUAL usage reduction.
7306: select mtl_material_transactions_s.nextval
7307: into txn_tmp_header_id
7308: from dual;
7309: */
7310:

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,

Line 7378: mtl_material_transactions_s.nextval /* Transaction Temp Id */

7374: 'N', /* WIP_COMMIT_FLAG */
7375: 'Y', /* PROCESS_FLAG */
7376: 'Y', /* POSTING_FLAG */
7377: -- txn_tmp_header_id /* Transaction Temp Id */
7378: mtl_material_transactions_s.nextval /* Transaction Temp Id */
7379: ) RETURNING transaction_temp_id into txn_tmp_header_id;
7380:
7381: if lbji_debug = 'Y' then
7382: fnd_file.put_line(fnd_file.log, 'Inserted '||SQL%ROWCOUNT||' rows into mmtt');