APPS.CSI_DEBUG_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1078: FROM mtl_material_transactions mmt,

1074: mmt.transfer_transaction_id,
1075: mtt.transaction_type_name,
1076: mtt.type_class,
1077: mtt.user_defined_flag
1078: FROM mtl_material_transactions mmt,
1079: mtl_transaction_types mtt
1080: WHERE mmt.transaction_id = p_txn_id
1081: AND mtt.transaction_type_id = mmt.transaction_type_id;
1082:

Line 1298: mtl_material_transactions mmt

1294: IS
1295: SELECT mmt.creation_date mtl_creation_date,
1296: mmt.transaction_id mtl_txn_id
1297: FROM mtl_unit_transactions mut,
1298: mtl_material_transactions mmt
1299: WHERE mut.serial_number = p_serial_number
1300: AND mut.inventory_item_id = p_item_id
1301: AND mmt.transaction_id = mut.transaction_id
1302: UNION ALL

Line 1307: mtl_material_transactions mmt

1303: SELECT mmt.creation_date mtl_creation_date,
1304: mmt.transaction_id mtl_txn_id
1305: FROM mtl_unit_transactions mut,
1306: mtl_transaction_lot_numbers mtln,
1307: mtl_material_transactions mmt
1308: WHERE mut.serial_number = p_serial_number
1309: AND mut.inventory_item_id = p_item_id
1310: AND mtln.organization_id = mut.organization_id
1311: AND mtln.transaction_date = mut.transaction_date

Line 1606: FROM mtl_material_transactions mmt,

1602: mmt_ind binary_integer := 0;
1603:
1604: CURSOR wip_txn_cur(p_wip_entity_id IN number, p_organization_id IN number) IS
1605: SELECT mmt.transaction_id
1606: FROM mtl_material_transactions mmt,
1607: mtl_system_items msi
1608: WHERE mmt.transaction_source_type_id = 5
1609: AND mmt.organization_id = p_organization_id
1610: AND mmt.transaction_source_id = p_wip_entity_id

Line 1908: FROM mtl_material_transactions

1904: l_error_flag varchar2(1);
1905:
1906: CURSOR ship_txn_cur(p_line_id IN number, p_item_id IN number) IS
1907: SELECT transaction_id
1908: FROM mtl_material_transactions
1909: WHERE transaction_source_type_id = 2
1910: AND transaction_action_id = 1
1911: AND inventory_item_id = p_item_id
1912: AND trx_source_line_id = p_line_id