APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_TRANSACTION_TYPES

Line 1036: From mtl_transaction_types mtt

1032: Order by transaction_date asc;
1033:
1034: Cursor get_type_name IS
1035: Select mtt.transaction_type_name
1036: From mtl_transaction_types mtt
1037: Where mtt.transaction_type_id = l_txn_type_id;
1038:
1039: Begin
1040: write_group_begin('Lot_attributes');

Line 1481: from MTL_TRANSACTION_TYPES mtt

1477: and ml.lookup_code=wlsm.transaction_type_id;
1478: else
1479: select mtt.transaction_type_name
1480: into p_material_txn_rec.transaction_type
1481: from MTL_TRANSACTION_TYPES mtt
1482: where mtt.transaction_type_id = l_transaction_type_id;
1483: end if;
1484:
1485: write_group_begin('transaction_details');

Line 1656: from MTL_TRANSACTION_TYPES mtt

1652: and ml.lookup_code=wlsm.transaction_type_id;
1653: else
1654: select mtt.transaction_type_name
1655: into p_pending_txn_rec.transaction_type
1656: from MTL_TRANSACTION_TYPES mtt
1657: where mtt.transaction_type_id = l_transaction_type_id;
1658: end if;
1659:
1660: if l_txn_status_code = 2 then