APPS.WSM_LBJ_INTERFACE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

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

7330:
7331: if csr_wlji%rowcount - prev_rowcount <> 0 then -- {{ one batch
7332: l_stmt_num := 50;
7333: -- getting the header_id to be populated for mmtt
7334: select mtl_material_transactions_s.nextval
7335: into l_mmtt_txn_hdr_id
7336: from dual;
7337:
7338: l_stmt_num := 60;

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

11787: '', -- Supply Type
11788: 'N', -- Wip_Commit_Flag
11789: 'Y', -- Process_Flag
11790: 'Y', -- Posting_Flag
11791: mtl_material_transactions_s.nextval
11792: ) RETURNING transaction_temp_id into l_txn_tmp_hdr_id;
11793: if lbji_debug = 'Y' then
11794: fnd_file.put_line(fnd_file.log,
11795: 'Inserted '||SQL%ROWCOUNT||' rows into mmtt');

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 (

Line 20988: from mtl_material_transactions

20984: and applied_resource_units <> 0)
20985: /* for bug fix 16327585 */
20986: or exists (
20987: select 'x'
20988: from mtl_material_transactions
20989: where organization_id = p_organization_id
20990: and transaction_source_type_id = 5
20991: and transaction_source_id = p_wip_entity_id
20992: and costed_flag in ('N', 'E')));