APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_TRANSACTION_TYPES

Line 1032: From mtl_transaction_types mtt

1028: Order by transaction_date asc;
1029:
1030: Cursor get_type_name IS
1031: Select mtt.transaction_type_name
1032: From mtl_transaction_types mtt
1033: Where mtt.transaction_type_id = l_txn_type_id;
1034:
1035: Begin
1036: write_group_begin('Lot_attributes');

Line 1477: from MTL_TRANSACTION_TYPES mtt

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

Line 1652: from MTL_TRANSACTION_TYPES mtt

1648: and ml.lookup_code=wlsm.transaction_type_id;
1649: else
1650: select mtt.transaction_type_name
1651: into p_pending_txn_rec.transaction_type
1652: from MTL_TRANSACTION_TYPES mtt
1653: where mtt.transaction_type_id = l_transaction_type_id;
1654: end if;
1655:
1656: if l_txn_status_code = 2 then