APPS.CSI_UTILITY_GRP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 339: mtl_material_transactions mmt

335: BEGIN
336: select 1
337: into l_record_found
338: from csi_txn_errors cte,
339: mtl_material_transactions mmt
340: where mmt.transaction_id = cte.inv_material_transaction_id
341: and mmt.inventory_item_id = p_item_id
342: and cte.processed_flag in ('R','E','W')
343: and rownum < 2;

Line 382: from mtl_material_transactions_temp mmtt

378:
379: BEGIN
380: select 1
381: into l_record_found
382: from mtl_material_transactions_temp mmtt
383: where mmtt.inventory_item_id = p_item_id
384: and mmtt.organization_id = p_org_id
385: and rownum < 2;
386:

Line 509: from mtl_material_transactions

505: IF l_source_id1 IS NULL THEN
506: BEGIN
507: select inventory_item_id
508: into l_item_id
509: from mtl_material_transactions
510: where transaction_id = l_source_id;
511:
512: IF p_item_id = l_item_id THEN
513: RETURN(TRUE);

Line 695: mtl_material_transactions mmt,

691: INTO l_config_keys.session_hdr_id,
692: l_config_keys.session_rev_num,
693: l_config_keys.session_item_id
694: FROM csi_txn_errors cte,
695: mtl_material_transactions mmt,
696: mtl_unit_transactions mut,
697: oe_order_lines_all ool
698: WHERE mmt.transaction_id = mut.transaction_id
699: AND mmt.transaction_action_id = 1

Line 756: FROM mtl_material_transactions mmt,

752: pc_transaction_id in NUMBER) IS
753: SELECT ool.config_header_id config_session_hdr_id,
754: ool.config_rev_nbr config_session_rev_num,
755: ool.configuration_id config_session_item_id
756: FROM mtl_material_transactions mmt,
757: mtl_unit_transactions mut,
758: oe_order_lines_all ool
759: WHERE mmt.transaction_id = mut.transaction_id
760: AND mmt.transaction_id = pc_transaction_id

Line 1363: FROM mtl_material_transactions

1359: CURSOR c_mtl_data (pc_from_date in DATE,
1360: pc_to_date in DATE) IS
1361: SELECT transaction_id,
1362: transaction_date
1363: FROM mtl_material_transactions
1364: WHERE transaction_date between pc_from_date and pc_to_date;
1365:
1366: CURSOR c_csi_txns (pc_transaction_id in NUMBER) IS
1367: SELECT 1